U.S. SBA Loan Data Analysis

Dataset statistics

Number of variables	36
Number of observations	588053
Missing cells	2085003
Missing cells (%)	9.8%
Duplicate rows	963
Duplicate rows (%)	0.2%
Total size in memory	161.5 MiB
Average record size in memory	288.0 B

Variable types

Categorical	25
Numeric	10
Unsupported	1

Dataset

Description	This profiling report was generated as part of Misiriya's KaggleX BIPOC project
URL

Alerts

`AsOfDate` has constant value "20200930"	Constant
`Program` has constant value "7A"	Constant
Dataset has 963 (0.2%) duplicate rows	Duplicates
`BorrName` has a high cardinality: 477025 distinct values	High cardinality
`BorrStreet` has a high cardinality: 510557 distinct values	High cardinality
`BorrCity` has a high cardinality: 26981 distinct values	High cardinality
`BorrState` has a high cardinality: 58 distinct values	High cardinality
`BankName` has a high cardinality: 3258 distinct values	High cardinality
`BankStreet` has a high cardinality: 3469 distinct values	High cardinality
`BankCity` has a high cardinality: 2184 distinct values	High cardinality
`BankState` has a high cardinality: 55 distinct values	High cardinality
`ApprovalDate` has a high cardinality: 3761 distinct values	High cardinality
`FirstDisbursementDate` has a high cardinality: 3530 distinct values	High cardinality
`NaicsDescription` has a high cardinality: 1220 distinct values	High cardinality
`FranchiseCode` has a high cardinality: 5444 distinct values	High cardinality
`FranchiseName` has a high cardinality: 4768 distinct values	High cardinality
`ProjectCounty` has a high cardinality: 1889 distinct values	High cardinality
`ProjectState` has a high cardinality: 58 distinct values	High cardinality
`SBADistrictOffice` has a high cardinality: 74 distinct values	High cardinality
`PaidInFullDate` has a high cardinality: 130 distinct values	High cardinality
`ChargeOffDate` has a high cardinality: 2184 distinct values	High cardinality
`BorrZip` is highly overall correlated with `BorrState` and 3 other fields	High correlation
`GrossApproval` is highly overall correlated with `SBAGuaranteedApproval` and 1 other fields	High correlation
`SBAGuaranteedApproval` is highly overall correlated with `GrossApproval` and 1 other fields	High correlation
`TermInMonths` is highly overall correlated with `GrossApproval` and 1 other fields	High correlation
`CongressionalDistrict` is highly overall correlated with `SBADistrictOffice`	High correlation
`BorrState` is highly overall correlated with `BorrZip` and 3 other fields	High correlation
`BankState` is highly overall correlated with `BorrZip` and 3 other fields	High correlation
`DeliveryMethod` is highly overall correlated with `subpgmdesc` and 1 other fields	High correlation
`subpgmdesc` is highly overall correlated with `DeliveryMethod` and 1 other fields	High correlation
`ProjectState` is highly overall correlated with `BorrZip` and 3 other fields	High correlation
`SBADistrictOffice` is highly overall correlated with `BorrZip` and 4 other fields	High correlation
`RevolverStatus` is highly overall correlated with `DeliveryMethod` and 1 other fields	High correlation
`DeliveryMethod` is highly imbalanced (50.3%)	Imbalance
`subpgmdesc` is highly imbalanced (59.8%)	Imbalance
`BusinessType` is highly imbalanced (61.6%)	Imbalance
`FirstDisbursementDate` has 82091 (14.0%) missing values	Missing
`FranchiseCode` has 534676 (90.9%) missing values	Missing
`FranchiseName` has 534790 (90.9%) missing values	Missing
`PaidInFullDate` has 365212 (62.1%) missing values	Missing
`ChargeOffDate` has 567384 (96.5%) missing values	Missing
`GrossChargeOffAmount` is highly skewed (γ1 = 29.43380104)	Skewed
`BorrName` is uniformly distributed	Uniform
`BorrStreet` is uniformly distributed	Uniform
`BankZip` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`CongressionalDistrict` has 19793 (3.4%) zeros	Zeros
`GrossChargeOffAmount` has 567384 (96.5%) zeros	Zeros
`JobsSupported` has 93989 (16.0%) zeros	Zeros

Reproduction

Analysis started	2023-03-20 13:15:38.489317
Analysis finished	2023-03-20 13:17:21.193447
Duration	1 minute and 42.7 seconds
Software version	pandas-profiling v0.0.dev0
Download configuration	config.json

AsOfDate
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

20200930	588053

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	4704424
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20200930
2nd row	20200930
3rd row	20200930
4th row	20200930
5th row	20200930

Common Values

Value	Count	Frequency (%)
20200930	588053	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
20200930	588053	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	2352212	50.0%
2	1176106	25.0%
9	588053	12.5%
3	588053	12.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4704424	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2352212	50.0%
2	1176106	25.0%
9	588053	12.5%
3	588053	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	4704424	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2352212	50.0%
2	1176106	25.0%
9	588053	12.5%
3	588053	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4704424	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2352212	50.0%
2	1176106	25.0%
9	588053	12.5%
3	588053	12.5%

Program
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

7A	588053

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1176106
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	7A
2nd row	7A
3rd row	7A
4th row	7A
5th row	7A

Common Values

Value	Count	Frequency (%)
7A	588053	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
7a	588053	100.0%

Most occurring characters

Value	Count	Frequency (%)
7	588053	50.0%
A	588053	50.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	588053	50.0%
Uppercase Letter	588053	50.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
7	588053	100.0%

Uppercase Letter

Value	Count	Frequency (%)
A	588053	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	588053	50.0%
Latin	588053	50.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
7	588053	100.0%

Latin

Value	Count	Frequency (%)
A	588053	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1176106	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	588053	50.0%
A	588053	50.0%

BorrName
Categorical

HIGH CARDINALITY UNIFORM

Distinct	477025
Distinct (%)	81.1%
Missing	37
Missing (%)	< 0.1%
Memory size	4.5 MiB

Entity to be formed	45
The Cove at River Oaks, LLC	42
Anytime Fitness	42
Sport Clips	37
Subway	34
Other values (477020)	587816

Length

Max length	30
Median length	23
Mean length	21.91991
Min length	1

Characters and Unicode

Total characters	12889258
Distinct characters	94
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	394960 ?
Unique (%)	67.2%

Sample

1st row	CRESA PARTNERS - DENVER, INC.
2nd row	The Hilltop Tavern
3rd row	River City Car Wash LLC
4th row	Alphagraphics
5th row	ON SITE AUTOMOTIVE APPEARANCE

Common Values

Value	Count	Frequency (%)
Entity to be formed	45	< 0.1%
The Cove at River Oaks, LLC	42	< 0.1%
Anytime Fitness	42	< 0.1%
Sport Clips	37	< 0.1%
Subway	34	< 0.1%
Briar Rose Estates, LLC	33	< 0.1%
HARDRIVES CONSTRUCTION INC	24	< 0.1%
Silly Zak's Gluten Free Bakery	21	< 0.1%
Vision Logistics Inc.	18	< 0.1%
Rock River Laboratory, Inc.	18	< 0.1%
Other values (477015)	587702	99.9%
(Missing)	37	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
llc	212975	10.2%
inc	157989	7.6%
	43744	2.1%
and	23507	1.1%
enterprises	15347	0.7%
group	14758	0.7%
services	14464	0.7%
the	13915	0.7%
of	11126	0.5%
company	9974	0.5%
Other values (175762)	1568671	75.2%

Most occurring characters

Value	Count	Frequency (%)
	1500385	11.6%
e	680673	5.3%
L	648760	5.0%
n	613572	4.8%
C	549330	4.3%
a	542809	4.2%
r	509387	4.0%
i	484366	3.8%
o	472812	3.7%
t	413909	3.2%
Other values (84)	6473255	50.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5983217	46.4%
Uppercase Letter	4842952	37.6%
Space Separator	1500385	11.6%
Other Punctuation	498744	3.9%
Decimal Number	46171	0.4%
Dash Punctuation	13186	0.1%
Open Punctuation	2381	< 0.1%
Close Punctuation	1851	< 0.1%
Math Symbol	314	< 0.1%
Modifier Symbol	20	< 0.1%
Other values (2)	37	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	680673	11.4%
n	613572	10.3%
a	542809	9.1%
r	509387	8.5%
i	484366	8.1%
o	472812	7.9%
t	413909	6.9%
s	380909	6.4%
c	306531	5.1%
l	291045	4.9%
Other values (17)	1287204	21.5%

Uppercase Letter

Value	Count	Frequency (%)
L	648760	13.4%
C	549330	11.3%
I	400320	8.3%
S	326625	6.7%
E	321354	6.6%
A	310180	6.4%
R	266426	5.5%
N	266212	5.5%
T	253978	5.2%
O	205620	4.2%
Other values (16)	1294147	26.7%

Other Punctuation

Value	Count	Frequency (%)
,	239296	48.0%
.	179243	35.9%
&	50555	10.1%
'	22102	4.4%
;	3166	0.6%
/	2516	0.5%
#	853	0.2%
:	389	0.1%
?	256	0.1%
!	237	< 0.1%
Other values (5)	131	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	8756	19.0%
2	8156	17.7%
3	5531	12.0%
0	5315	11.5%
4	4571	9.9%
5	3669	7.9%
6	2649	5.7%
8	2595	5.6%
9	2474	5.4%
7	2455	5.3%

Math Symbol

Value	Count	Frequency (%)
+	299	95.2%
>	7	2.2%
<	4	1.3%
=	3	1.0%
\|	1	0.3%

Open Punctuation

Value	Count	Frequency (%)
(	2371	99.6%
[	9	0.4%
{	1	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	1843	99.6%
]	8	0.4%

Modifier Symbol

Value	Count	Frequency (%)
`	18	90.0%
^	2	10.0%

Space Separator

Value	Count	Frequency (%)
	1500385	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13186	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	19	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	18	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10826169	84.0%
Common	2063089	16.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	680673	6.3%
L	648760	6.0%
n	613572	5.7%
C	549330	5.1%
a	542809	5.0%
r	509387	4.7%
i	484366	4.5%
o	472812	4.4%
t	413909	3.8%
I	400320	3.7%
Other values (43)	5510231	50.9%

Common

Value	Count	Frequency (%)
	1500385	72.7%
,	239296	11.6%
.	179243	8.7%
&	50555	2.5%
'	22102	1.1%
-	13186	0.6%
1	8756	0.4%
2	8156	0.4%
3	5531	0.3%
0	5315	0.3%
Other values (31)	30564	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12889257	> 99.9%
None	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1500385	11.6%
e	680673	5.3%
L	648760	5.0%
n	613572	4.8%
C	549330	4.3%
a	542809	4.2%
r	509387	4.0%
i	484366	3.8%
o	472812	3.7%
t	413909	3.2%
Other values (83)	6473254	50.2%

None

Value	Count	Frequency (%)
ú	1	100.0%

BorrStreet
Categorical

HIGH CARDINALITY UNIFORM

Distinct	510557
Distinct (%)	86.8%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

TBD	67
Main Street	45
1111 Parana	24
PO BOX	18
Main St	17
Other values (510552)	587882

Length

Max length	30
Median length	24
Mean length	19.306285
Min length	1

Characters and Unicode

Total characters	11353119
Distinct characters	87
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	448838 ?
Unique (%)	76.3%

Sample

1st row	7979 E TUFTS AVE PKWY STE 810
2nd row	4757 Folsom Blvd
3rd row	649 Harbor Blvd
4th row	71 Newtown Road.
5th row	603 WOODBRIDGE COURT

Common Values

Value	Count	Frequency (%)
TBD	67	< 0.1%
Main Street	45	< 0.1%
1111 Parana	24	< 0.1%
PO BOX	18	< 0.1%
Main St	17	< 0.1%
MAIN ST	15	< 0.1%
21107 Omega Circle	15	< 0.1%
2781 Kikihau St	15	< 0.1%
400 Hana Highway A1	14	< 0.1%
7207 CANTERWOOD PL	14	< 0.1%
Other values (510547)	587809	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
st	71502	3.1%
street	65691	2.9%
ave	64589	2.8%
rd	56175	2.5%
road	55062	2.4%
suite	38234	1.7%
dr	34927	1.5%
w	32453	1.4%
n	31993	1.4%
s	31946	1.4%
Other values (93873)	1796979	78.8%

Most occurring characters

Value	Count	Frequency (%)
	1696023	14.9%
e	593794	5.2%
1	490793	4.3%
t	432535	3.8%
0	383839	3.4%
S	381283	3.4%
a	349288	3.1%
r	336053	3.0%
2	322438	2.8%
E	289771	2.6%
Other values (77)	6077302	53.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3829869	33.7%
Uppercase Letter	3126859	27.5%
Decimal Number	2530562	22.3%
Space Separator	1696023	14.9%
Other Punctuation	155841	1.4%
Dash Punctuation	13636	0.1%
Open Punctuation	175	< 0.1%
Close Punctuation	93	< 0.1%
Modifier Symbol	24	< 0.1%
Math Symbol	15	< 0.1%
Other values (2)	22	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	593794	15.5%
t	432535	11.3%
a	349288	9.1%
r	336053	8.8%
o	276569	7.2%
n	260969	6.8%
i	254439	6.6%
l	195079	5.1%
d	190308	5.0%
u	141834	3.7%
Other values (16)	799001	20.9%

Uppercase Letter

Value	Count	Frequency (%)
S	381283	12.2%
E	289771	9.3%
R	285348	9.1%
A	275181	8.8%
T	197979	6.3%
N	184559	5.9%
D	174870	5.6%
L	145024	4.6%
W	133325	4.3%
C	125606	4.0%
Other values (16)	933913	29.9%

Other Punctuation

Value	Count	Frequency (%)
.	104621	67.1%
,	26781	17.2%
#	19031	12.2%
&	3439	2.2%
/	1054	0.7%
'	571	0.4%
;	181	0.1%
?	113	0.1%
:	25	< 0.1%
@	14	< 0.1%
Other values (3)	11	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	490793	19.4%
0	383839	15.2%
2	322438	12.7%
5	246514	9.7%
3	246295	9.7%
4	215262	8.5%
6	171167	6.8%
7	162564	6.4%
8	149007	5.9%
9	142683	5.6%

Math Symbol

Value	Count	Frequency (%)
+	11	73.3%
=	2	13.3%
<	1	6.7%
>	1	6.7%

Modifier Symbol

Value	Count	Frequency (%)
`	22	91.7%
^	2	8.3%

Space Separator

Value	Count	Frequency (%)
	1696023	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13636	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	175	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	93	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	14	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6956728	61.3%
Common	4396391	38.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	593794	8.5%
t	432535	6.2%
S	381283	5.5%
a	349288	5.0%
r	336053	4.8%
E	289771	4.2%
R	285348	4.1%
o	276569	4.0%
A	275181	4.0%
n	260969	3.8%
Other values (42)	3475937	50.0%

Common

Value	Count	Frequency (%)
	1696023	38.6%
1	490793	11.2%
0	383839	8.7%
2	322438	7.3%
5	246514	5.6%
3	246295	5.6%
4	215262	4.9%
6	171167	3.9%
7	162564	3.7%
8	149007	3.4%
Other values (25)	312489	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11353119	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1696023	14.9%
e	593794	5.2%
1	490793	4.3%
t	432535	3.8%
0	383839	3.4%
S	381283	3.4%
a	349288	3.1%
r	336053	3.0%
2	322438	2.8%
E	289771	2.6%
Other values (77)	6077302	53.5%

BorrCity
Categorical

Distinct	26981
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

LOS ANGELES	4451
HOUSTON	3858
NEW YORK	3356
CHICAGO	2965
BROOKLYN	2404
Other values (26976)	571019

Length

Max length	30
Median length	27
Mean length	8.8787014
Min length	1

Characters and Unicode

Total characters	5221147
Distinct characters	76
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8160 ?
Unique (%)	1.4%

Sample

1st row	DENVER
2nd row	Sacramento
3rd row	West Sacramento
4th row	Danbury
5th row	MIDDLEBURY

Common Values

Value	Count	Frequency (%)
LOS ANGELES	4451	0.8%
HOUSTON	3858	0.7%
NEW YORK	3356	0.6%
CHICAGO	2965	0.5%
BROOKLYN	2404	0.4%
SAN DIEGO	2213	0.4%
DENVER	2200	0.4%
DALLAS	2106	0.4%
LAS VEGAS	1988	0.3%
PORTLAND	1968	0.3%
Other values (26971)	560544	95.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
city	14248	1.9%
san	13124	1.7%
new	9388	1.2%
beach	6862	0.9%
park	6820	0.9%
lake	6700	0.9%
los	6668	0.9%
angeles	6360	0.8%
houston	5789	0.8%
fort	5499	0.7%
Other values (12448)	681210	89.3%

Most occurring characters

Value	Count	Frequency (%)
A	331257	6.3%
E	302588	5.8%
N	272567	5.2%
O	266799	5.1%
L	258577	5.0%
R	222752	4.3%
S	218519	4.2%
I	197836	3.8%
e	185021	3.5%
T	181114	3.5%
Other values (66)	2784117	53.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3346837	64.1%
Lowercase Letter	1695400	32.5%
Space Separator	174654	3.3%
Other Punctuation	2286	< 0.1%
Open Punctuation	812	< 0.1%
Decimal Number	543	< 0.1%
Close Punctuation	500	< 0.1%
Dash Punctuation	114	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	331257	9.9%
E	302588	9.0%
N	272567	8.1%
O	266799	8.0%
L	258577	7.7%
R	222752	6.7%
S	218519	6.5%
I	197836	5.9%
T	181114	5.4%
C	137672	4.1%
Other values (16)	957156	28.6%

Lowercase Letter

Value	Count	Frequency (%)
e	185021	10.9%
a	178448	10.5%
n	157881	9.3%
o	157541	9.3%
l	137810	8.1%
i	127018	7.5%
r	125874	7.4%
t	107256	6.3%
s	90458	5.3%
d	55336	3.3%
Other values (16)	372757	22.0%

Decimal Number

Value	Count	Frequency (%)
4	104	19.2%
1	78	14.4%
0	70	12.9%
2	62	11.4%
3	54	9.9%
5	41	7.6%
9	38	7.0%
6	36	6.6%
7	33	6.1%
8	27	5.0%

Other Punctuation

Value	Count	Frequency (%)
.	1601	70.0%
,	413	18.1%
'	221	9.7%
?	18	0.8%
/	16	0.7%
&	8	0.3%
;	3	0.1%
#	3	0.1%
:	3	0.1%

Space Separator

Value	Count	Frequency (%)
	174654	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	812	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	500	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	114	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5042237	96.6%
Common	178910	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	331257	6.6%
E	302588	6.0%
N	272567	5.4%
O	266799	5.3%
L	258577	5.1%
R	222752	4.4%
S	218519	4.3%
I	197836	3.9%
e	185021	3.7%
T	181114	3.6%
Other values (42)	2605207	51.7%

Common

Value	Count	Frequency (%)
	174654	97.6%
.	1601	0.9%
(	812	0.5%
)	500	0.3%
,	413	0.2%
'	221	0.1%
-	114	0.1%
4	104	0.1%
1	78	< 0.1%
0	70	< 0.1%
Other values (14)	343	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5221147	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	331257	6.3%
E	302588	5.8%
N	272567	5.2%
O	266799	5.1%
L	258577	5.0%
R	222752	4.3%
S	218519	4.2%
I	197836	3.8%
e	185021	3.5%
T	181114	3.5%
Other values (66)	2784117	53.3%

BorrState
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	58
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

CA	73442
TX	44854
NY	37443
OH	33449
FL	28681
Other values (53)	370184

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1176106
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	CO
2nd row	CA
3rd row	CA
4th row	CT
5th row	IN

Common Values

Value	Count	Frequency (%)
CA	73442	12.5%
TX	44854	7.6%
NY	37443	6.4%
OH	33449	5.7%
FL	28681	4.9%
MI	22977	3.9%
MA	20755	3.5%
IL	19445	3.3%
PA	18836	3.2%
MN	16981	2.9%
Other values (48)	271190	46.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	73442	12.5%
tx	44854	7.6%
ny	37443	6.4%
oh	33449	5.7%
fl	28681	4.9%
mi	22977	3.9%
ma	20755	3.5%
il	19445	3.3%
pa	18836	3.2%
mn	16981	2.9%
Other values (48)	271190	46.1%

Most occurring characters

Value	Count	Frequency (%)
A	183967	15.6%
N	119588	10.2%
C	111834	9.5%
M	94419	8.0%
I	87937	7.5%
T	74089	6.3%
O	72655	6.2%
L	56887	4.8%
X	44854	3.8%
Y	43944	3.7%
Other values (14)	285932	24.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1176106	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	183967	15.6%
N	119588	10.2%
C	111834	9.5%
M	94419	8.0%
I	87937	7.5%
T	74089	6.3%
O	72655	6.2%
L	56887	4.8%
X	44854	3.8%
Y	43944	3.7%
Other values (14)	285932	24.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1176106	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	183967	15.6%
N	119588	10.2%
C	111834	9.5%
M	94419	8.0%
I	87937	7.5%
T	74089	6.3%
O	72655	6.2%
L	56887	4.8%
X	44854	3.8%
Y	43944	3.7%
Other values (14)	285932	24.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1176106	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	183967	15.6%
N	119588	10.2%
C	111834	9.5%
M	94419	8.0%
I	87937	7.5%
T	74089	6.3%
O	72655	6.2%
L	56887	4.8%
X	44854	3.8%
Y	43944	3.7%
Other values (14)	285932	24.3%

BorrZip
Real number (ℝ)

Distinct	24334
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52318.167

Minimum	601
Maximum	99929
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	601
5-th percentile	3031
Q1	27954
median	50613
Q3	80238
95-th percentile	96150
Maximum	99929
Range	99328
Interquartile range (IQR)	52284

Descriptive statistics

Standard deviation	30775.38
Coefficient of variation (CV)	0.58823506
Kurtosis	-1.2879899
Mean	52318.167
Median Absolute Deviation (MAD)	28141
Skewness	-0.083580435
Sum	3.0765855 × 10¹⁰
Variance	9.47124 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10001	540	0.1%
90021	414	0.1%
75034	395	0.1%
33166	371	0.1%
93401	355	0.1%
46032	352	0.1%
10018	349	0.1%
85260	345	0.1%
90015	341	0.1%
84115	335	0.1%
Other values (24324)	584256	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
601	10	< 0.1%
602	64	< 0.1%
603	93	< 0.1%
604	2	< 0.1%
605	14	< 0.1%
606	2	< 0.1%
610	44	< 0.1%
612	73	< 0.1%
613	2	< 0.1%
614	6	< 0.1%

Value	Count	Frequency (%)
99929	3	< 0.1%
99925	3	< 0.1%
99921	7	< 0.1%
99919	1	< 0.1%
99901	54	< 0.1%
99841	1	< 0.1%
99840	16	< 0.1%
99835	27	< 0.1%
99833	8	< 0.1%
99832	5	< 0.1%

BankName
Categorical

Distinct	3258
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

Wells Fargo Bank, National Association	46635
The Huntington National Bank	38631
JPMorgan Chase Bank, National Association	36302
U.S. Bank, National Association	27943
TD Bank, National Association	16908
Other values (3253)	421634

Length

Max length	60
Median length	50
Mean length	25.526407
Min length	3

Characters and Unicode

Total characters	15010880
Distinct characters	75
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	445 ?
Unique (%)	0.1%

Sample

1st row	Zions Bank, A Division of
2nd row	Plumas Bank
3rd row	Wells Fargo Bank, National Association
4th row	Union Savings Bank
5th row	VelocitySBA, LLC

Common Values

Value	Count	Frequency (%)
Wells Fargo Bank, National Association	46635	7.9%
The Huntington National Bank	38631	6.6%
JPMorgan Chase Bank, National Association	36302	6.2%
U.S. Bank, National Association	27943	4.8%
TD Bank, National Association	16908	2.9%
Manufacturers and Traders Trust Company	13877	2.4%
BBVA USA	11992	2.0%
Celtic Bank Corporation	8811	1.5%
Live Oak Banking Company	8565	1.5%
Truist Bank d/b/a Branch Banking & Trust Co	8279	1.4%
Other values (3248)	370110	62.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bank	481364	22.2%
national	245889	11.3%
association	186924	8.6%
the	53049	2.4%
fargo	46690	2.2%
wells	46644	2.1%
of	43280	2.0%
trust	41643	1.9%
huntington	38631	1.8%
chase	36302	1.7%
Other values (2239)	949400	43.8%

Most occurring characters

Value	Count	Frequency (%)
a	1737693	11.6%
	1581857	10.5%
n	1542405	10.3%
i	1084555	7.2%
o	1073535	7.2%
t	883163	5.9%
s	787292	5.2%
B	608361	4.1%
e	575456	3.8%
k	551047	3.7%
Other values (65)	4585516	30.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10701953	71.3%
Uppercase Letter	2397225	16.0%
Space Separator	1581857	10.5%
Other Punctuation	322605	2.1%
Decimal Number	4322	< 0.1%
Dash Punctuation	2331	< 0.1%
Open Punctuation	284	< 0.1%
Close Punctuation	284	< 0.1%
Math Symbol	19	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1737693	16.2%
n	1542405	14.4%
i	1084555	10.1%
o	1073535	10.0%
t	883163	8.3%
s	787292	7.4%
e	575456	5.4%
k	551047	5.1%
l	474548	4.4%
r	451393	4.2%
Other values (16)	1540866	14.4%

Uppercase Letter

Value	Count	Frequency (%)
B	608361	25.4%
N	274017	11.4%
A	253137	10.6%
C	221792	9.3%
T	147367	6.1%
F	136670	5.7%
S	135201	5.6%
U	80087	3.3%
P	77080	3.2%
M	76859	3.2%
Other values (16)	386654	16.1%

Decimal Number

Value	Count	Frequency (%)
1	2975	68.8%
2	549	12.7%
3	198	4.6%
0	194	4.5%
4	164	3.8%
5	112	2.6%
6	89	2.1%
7	23	0.5%
8	18	0.4%

Other Punctuation

Value	Count	Frequency (%)
,	207675	64.4%
.	73937	22.9%
/	19259	6.0%
&	18580	5.8%
'	3150	1.0%
\	2	< 0.1%
"	2	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	9	47.4%
<	5	26.3%
>	5	26.3%

Space Separator

Value	Count	Frequency (%)
	1581857	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2331	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	284	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	284	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13099178	87.3%
Common	1911702	12.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1737693	13.3%
n	1542405	11.8%
i	1084555	8.3%
o	1073535	8.2%
t	883163	6.7%
s	787292	6.0%
B	608361	4.6%
e	575456	4.4%
k	551047	4.2%
l	474548	3.6%
Other values (42)	3781123	28.9%

Common

Value	Count	Frequency (%)
	1581857	82.7%
,	207675	10.9%
.	73937	3.9%
/	19259	1.0%
&	18580	1.0%
'	3150	0.2%
1	2975	0.2%
-	2331	0.1%
2	549	< 0.1%
(	284	< 0.1%
Other values (13)	1105	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15010880	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1737693	11.6%
	1581857	10.5%
n	1542405	10.3%
i	1084555	7.2%
o	1073535	7.2%
t	883163	5.9%
s	787292	5.2%
B	608361	4.1%
e	575456	3.8%
k	551047	3.7%
Other values (65)	4585516	30.5%

BankStreet
Categorical

Distinct	3469
Distinct (%)	0.6%
Missing	4
Missing (%)	< 0.1%
Memory size	4.5 MiB

101 N Philips Ave	46635
17 S High St	38631
1111 Polaris Pkwy	36302
425 Walnut St	27943
2035 Limestone Rd	16908
Other values (3464)	421630

Length

Max length	30
Median length	27
Mean length	16.855216
Min length	8

Characters and Unicode

Total characters	9911693
Distinct characters	74
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	477 ?
Unique (%)	0.1%

Sample

1st row	1 S Main St
2nd row	336 W Main St
3rd row	101 N Philips Ave
4th row	226 Main St
5th row	9385 Haven Avenue

Common Values

Value	Count	Frequency (%)
101 N Philips Ave	46635	7.9%
17 S High St	38631	6.6%
1111 Polaris Pkwy	36302	6.2%
425 Walnut St	27943	4.8%
2035 Limestone Rd	16908	2.9%
One M & T Plaza, 15th Fl	13877	2.4%
15 S 20th St	11992	2.0%
268 S State St, Ste 300	8811	1.5%
1741 Tiburon Dr	8565	1.5%
214 N Tryon St	8279	1.4%
Other values (3459)	370106	62.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
st	254015	11.2%
ave	101252	4.4%
n	100419	4.4%
s	100021	4.4%
ste	63642	2.8%
101	53433	2.3%
main	48136	2.1%
philips	46635	2.0%
pkwy	39720	1.7%
high	39129	1.7%
Other values (3179)	1431577	62.8%

Most occurring characters

Value	Count	Frequency (%)
	1689937	17.0%
1	632448	6.4%
t	578993	5.8%
S	482726	4.9%
e	474284	4.8%
i	423755	4.3%
0	423374	4.3%
a	371394	3.7%
n	330798	3.3%
l	310763	3.1%
Other values (64)	4193221	42.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4378249	44.2%
Decimal Number	2109100	21.3%
Space Separator	1689937	17.0%
Uppercase Letter	1598294	16.1%
Other Punctuation	121141	1.2%
Math Symbol	9305	0.1%
Dash Punctuation	5665	0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	578993	13.2%
e	474284	10.8%
i	423755	9.7%
a	371394	8.5%
n	330798	7.6%
l	310763	7.1%
r	279740	6.4%
s	219466	5.0%
o	219408	5.0%
h	206675	4.7%
Other values (16)	962973	22.0%

Uppercase Letter

Value	Count	Frequency (%)
S	482726	30.2%
P	175100	11.0%
A	130875	8.2%
N	118165	7.4%
M	96061	6.0%
W	88439	5.5%
H	65913	4.1%
R	58065	3.6%
B	53426	3.3%
F	50951	3.2%
Other values (16)	278573	17.4%

Decimal Number

Value	Count	Frequency (%)
1	632448	30.0%
0	423374	20.1%
2	234938	11.1%
5	192540	9.1%
7	136417	6.5%
4	135467	6.4%
3	130178	6.2%
9	80696	3.8%
8	74890	3.6%
6	68152	3.2%

Other Punctuation

Value	Count	Frequency (%)
,	92959	76.7%
&	15015	12.4%
.	11459	9.5%
'	953	0.8%
#	547	0.5%
/	208	0.2%

Math Symbol

Value	Count	Frequency (%)
<	4653	50.0%
>	4652	50.0%

Space Separator

Value	Count	Frequency (%)
	1689937	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5665	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5976543	60.3%
Common	3935150	39.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	578993	9.7%
S	482726	8.1%
e	474284	7.9%
i	423755	7.1%
a	371394	6.2%
n	330798	5.5%
l	310763	5.2%
r	279740	4.7%
s	219466	3.7%
o	219408	3.7%
Other values (42)	2285216	38.2%

Common

Value	Count	Frequency (%)
	1689937	42.9%
1	632448	16.1%
0	423374	10.8%
2	234938	6.0%
5	192540	4.9%
7	136417	3.5%
4	135467	3.4%
3	130178	3.3%
,	92959	2.4%
9	80696	2.1%
Other values (12)	186196	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9911693	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1689937	17.0%
1	632448	6.4%
t	578993	5.8%
S	482726	4.9%
e	474284	4.8%
i	423755	4.3%
0	423374	4.3%
a	371394	3.7%
n	330798	3.3%
l	310763	3.1%
Other values (64)	4193221	42.3%

BankCity
Categorical

Distinct	2184
Distinct (%)	0.4%
Missing	4
Missing (%)	< 0.1%
Memory size	4.5 MiB

COLUMBUS	76399
SIOUX FALLS	50551
WILMINGTON	34735
CINCINNATI	32285
SALT LAKE CITY	16659
Other values (2179)	377420

Length

Max length	24
Median length	21
Mean length	9.4283691
Min length	3

Characters and Unicode

Total characters	5544343
Distinct characters	53
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	250 ?
Unique (%)	< 0.1%

Sample

1st row	SALT LAKE CITY
2nd row	QUINCY
3rd row	SIOUX FALLS
4th row	DANBURY
5th row	Rancho Cucamonga

Common Values

Value	Count	Frequency (%)
COLUMBUS	76399	13.0%
SIOUX FALLS	50551	8.6%
WILMINGTON	34735	5.9%
CINCINNATI	32285	5.5%
SALT LAKE CITY	16659	2.8%
LOS ANGELES	16486	2.8%
BIRMINGHAM	14120	2.4%
BUFFALO	13967	2.4%
CHARLOTTE	10841	1.8%
CLEVELAND	7874	1.3%
Other values (2174)	314132	53.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
columbus	76504	9.5%
falls	51276	6.4%
sioux	50606	6.3%
wilmington	34801	4.3%
cincinnati	32285	4.0%
city	28343	3.5%
lake	22569	2.8%
salt	16709	2.1%
los	16693	2.1%
angeles	16693	2.1%
Other values (2008)	458012	56.9%

Most occurring characters

Value	Count	Frequency (%)
L	517427	9.3%
A	440024	7.9%
I	437492	7.9%
N	407047	7.3%
O	402274	7.3%
S	399668	7.2%
E	322974	5.8%
C	292276	5.3%
U	285975	5.2%
T	261815	4.7%
Other values (43)	1777371	32.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5110099	92.2%
Lowercase Letter	217670	3.9%
Space Separator	216442	3.9%
Other Punctuation	132	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	517427	10.1%
A	440024	8.6%
I	437492	8.6%
N	407047	8.0%
O	402274	7.9%
S	399668	7.8%
E	322974	6.3%
C	292276	5.7%
U	285975	5.6%
T	261815	5.1%
Other values (16)	1343127	26.3%

Lowercase Letter

Value	Count	Frequency (%)
a	31836	14.6%
n	25219	11.6%
o	19412	8.9%
e	17907	8.2%
r	14489	6.7%
u	13607	6.3%
g	13011	6.0%
c	12906	5.9%
t	12635	5.8%
i	10345	4.8%
Other values (14)	46303	21.3%

Other Punctuation

Value	Count	Frequency (%)
'	81	61.4%
.	51	38.6%

Space Separator

Value	Count	Frequency (%)
	216442	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5327769	96.1%
Common	216574	3.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	517427	9.7%
A	440024	8.3%
I	437492	8.2%
N	407047	7.6%
O	402274	7.6%
S	399668	7.5%
E	322974	6.1%
C	292276	5.5%
U	285975	5.4%
T	261815	4.9%
Other values (40)	1560797	29.3%

Common

Value	Count	Frequency (%)
	216442	99.9%
'	81	< 0.1%
.	51	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5544343	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
L	517427	9.3%
A	440024	7.9%
I	437492	7.9%
N	407047	7.3%
O	402274	7.3%
S	399668	7.2%
E	322974	5.8%
C	292276	5.3%
U	285975	5.2%
T	261815	4.7%
Other values (43)	1777371	32.1%

BankState
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	55
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	4.5 MiB

OH	121906
CA	52910
SD	51478
NY	29944
DE	26274
Other values (50)	305537

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1176098
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	UT
2nd row	CA
3rd row	SD
4th row	CT
5th row	CA

Common Values

Value	Count	Frequency (%)
OH	121906	20.7%
CA	52910	9.0%
SD	51478	8.8%
NY	29944	5.1%
DE	26274	4.5%
NC	23601	4.0%
UT	21333	3.6%
MA	20427	3.5%
TX	18702	3.2%
MN	14961	2.5%
Other values (45)	206513	35.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
oh	121906	20.7%
ca	52910	9.0%
sd	51478	8.8%
ny	29944	5.1%
de	26274	4.5%
nc	23601	4.0%
ut	21333	3.6%
ma	20427	3.5%
tx	18702	3.2%
mn	14961	2.5%
Other values (45)	206513	35.1%

Most occurring characters

Value	Count	Frequency (%)
A	142276	12.1%
O	140820	12.0%
H	127063	10.8%
N	96635	8.2%
C	84415	7.2%
D	82931	7.1%
M	63925	5.4%
S	60839	5.2%
I	56898	4.8%
T	54877	4.7%
Other values (15)	265419	22.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1176097	> 99.9%
Lowercase Letter	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	142276	12.1%
O	140820	12.0%
H	127063	10.8%
N	96635	8.2%
C	84415	7.2%
D	82931	7.1%
M	63925	5.4%
S	60839	5.2%
I	56898	4.8%
T	54877	4.7%
Other values (14)	265418	22.6%

Lowercase Letter

Value	Count	Frequency (%)
n	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1176098	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	142276	12.1%
O	140820	12.0%
H	127063	10.8%
N	96635	8.2%
C	84415	7.2%
D	82931	7.1%
M	63925	5.4%
S	60839	5.2%
I	56898	4.8%
T	54877	4.7%
Other values (15)	265419	22.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1176098	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	142276	12.1%
O	140820	12.0%
H	127063	10.8%
N	96635	8.2%
C	84415	7.2%
D	82931	7.1%
M	63925	5.4%
S	60839	5.2%
I	56898	4.8%
T	54877	4.7%
Other values (15)	265419	22.6%

BankZip
Unsupported

REJECTED UNSUPPORTED

Missing	4
Missing (%)	< 0.1%
Memory size	4.5 MiB

GrossApproval
Real number (ℝ)

Distinct	22149
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	393387.47

Minimum	1000
Maximum	5000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1000
5-th percentile	10000
Q1	45000
median	137500
Q3	381000
95-th percentile	1762500
Maximum	5000000
Range	4999000
Interquartile range (IQR)	336000

Descriptive statistics

Standard deviation	695480.22
Coefficient of variation (CV)	1.7679267
Kurtosis	14.87773
Mean	393387.47
Median Absolute Deviation (MAD)	112500
Skewness	3.5098264
Sum	2.3133268 × 10¹¹
Variance	4.8369274 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50000	38301	6.5%
25000	34004	5.8%
100000	29006	4.9%
150000	28342	4.8%
10000	20256	3.4%
350000	15196	2.6%
20000	14203	2.4%
15000	12876	2.2%
250000	11020	1.9%
30000	10421	1.8%
Other values (22139)	374428	63.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	19	< 0.1%
1500	4	< 0.1%
1600	1	< 0.1%
1700	1	< 0.1%
1900	1	< 0.1%
2000	12	< 0.1%
2300	2	< 0.1%
2400	2	< 0.1%
2500	17	< 0.1%
2600	2	< 0.1%

Value	Count	Frequency (%)
5000000	1898	0.3%
4999900	3	< 0.1%
4999700	1	< 0.1%
4999500	1	< 0.1%
4999000	1	< 0.1%
4998600	1	< 0.1%
4998200	1	< 0.1%
4998100	1	< 0.1%
4998000	4	< 0.1%
4997000	1	< 0.1%

SBAGuaranteedApproval
Real number (ℝ)

Distinct	29376
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	291622.72

Minimum	500
Maximum	6175000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	500
5-th percentile	5000
Q1	25000
median	87500
Q3	288750
95-th percentile	1350000
Maximum	6175000
Range	6174500
Interquartile range (IQR)	263750

Descriptive statistics

Standard deviation	534271.76
Coefficient of variation (CV)	1.832065
Kurtosis	15.186445
Mean	291622.72
Median Absolute Deviation (MAD)	75000
Skewness	3.5212083
Sum	1.7148961 × 10¹¹
Variance	2.8544631 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25000	33927	5.8%
12500	30767	5.2%
50000	22195	3.8%
5000	18816	3.2%
127500	17082	2.9%
10000	13100	2.2%
7500	11719	2.0%
75000	10628	1.8%
15000	9580	1.6%
2500	8383	1.4%
Other values (29366)	411856	70.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
500	19	< 0.1%
750	4	< 0.1%
800	1	< 0.1%
850	1	< 0.1%
950	1	< 0.1%
1000	12	< 0.1%
1150	2	< 0.1%
1200	2	< 0.1%
1250	16	< 0.1%
1300	2	< 0.1%

Value	Count	Frequency (%)
6175000	1	< 0.1%
5400000	1	< 0.1%
5250000	1	< 0.1%
5124526	1	< 0.1%
4556600	1	< 0.1%
4500000	276	< 0.1%
4498740	1	< 0.1%
4493718	1	< 0.1%
4492530	1	< 0.1%
4490370	1	< 0.1%

ApprovalDate
Categorical

Distinct	3761
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

11-03-2010	1500
28-07-2015	1358
01-10-2010	1082
24-12-2009	1001
28-01-2019	976
Other values (3756)	582136

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	5880530
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	197 ?
Unique (%)	< 0.1%

Sample

1st row	01-10-2009
2nd row	01-10-2009
3rd row	01-10-2009
4th row	01-10-2009
5th row	01-10-2009

Common Values

Value	Count	Frequency (%)
11-03-2010	1500	0.3%
28-07-2015	1358	0.2%
01-10-2010	1082	0.2%
24-12-2009	1001	0.2%
28-01-2019	976	0.2%
22-07-2015	955	0.2%
30-09-2013	912	0.2%
20-11-2009	902	0.2%
21-07-2015	880	0.1%
23-07-2015	815	0.1%
Other values (3751)	577672	98.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
11-03-2010	1500	0.3%
28-07-2015	1358	0.2%
01-10-2010	1082	0.2%
24-12-2009	1001	0.2%
28-01-2019	976	0.2%
22-07-2015	955	0.2%
30-09-2013	912	0.2%
20-11-2009	902	0.2%
21-07-2015	880	0.1%
23-07-2015	815	0.1%
Other values (3751)	577672	98.2%

Most occurring characters

Value	Count	Frequency (%)
0	1386831	23.6%
-	1176106	20.0%
1	1081879	18.4%
2	1027143	17.5%
3	185939	3.2%
9	178953	3.0%
7	172461	2.9%
6	170441	2.9%
5	169680	2.9%
8	167492	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4704424	80.0%
Dash Punctuation	1176106	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1386831	29.5%
1	1081879	23.0%
2	1027143	21.8%
3	185939	4.0%
9	178953	3.8%
7	172461	3.7%
6	170441	3.6%
5	169680	3.6%
8	167492	3.6%
4	163605	3.5%

Dash Punctuation

Value	Count	Frequency (%)
-	1176106	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5880530	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1386831	23.6%
-	1176106	20.0%
1	1081879	18.4%
2	1027143	17.5%
3	185939	3.2%
9	178953	3.0%
7	172461	2.9%
6	170441	2.9%
5	169680	2.9%
8	167492	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5880530	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1386831	23.6%
-	1176106	20.0%
1	1081879	18.4%
2	1027143	17.5%
3	185939	3.2%
9	178953	3.0%
7	172461	2.9%
6	170441	2.9%
5	169680	2.9%
8	167492	2.8%

ApprovalFiscalYear
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2015.1043

Minimum	2010
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	2010
5-th percentile	2010
Q1	2013
median	2015
Q3	2018
95-th percentile	2020
Maximum	2020
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.0331319
Coefficient of variation (CV)	0.0015051985
Kurtosis	-1.1194012
Mean	2015.1043
Median Absolute Deviation (MAD)	3
Skewness	-0.11117726
Sum	1.1849881 × 10⁹
Variance	9.1998893
Monotonicity	Increasing

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
2016	64074	10.9%
2015	63461	10.8%
2017	62430	10.6%
2018	60354	10.3%
2011	53710	9.1%
2014	52044	8.9%
2019	51907	8.8%
2010	47000	8.0%
2013	46395	7.9%
2012	44376	7.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	47000	8.0%
2011	53710	9.1%
2012	44376	7.5%
2013	46395	7.9%
2014	52044	8.9%
2015	63461	10.8%
2016	64074	10.9%
2017	62430	10.6%
2018	60354	10.3%
2019	51907	8.8%

Value	Count	Frequency (%)
2020	42302	7.2%
2019	51907	8.8%
2018	60354	10.3%
2017	62430	10.6%
2016	64074	10.9%
2015	63461	10.8%
2014	52044	8.9%
2013	46395	7.9%
2012	44376	7.5%
2011	53710	9.1%

FirstDisbursementDate
Categorical

HIGH CARDINALITY MISSING

Distinct	3530
Distinct (%)	0.7%
Missing	82091
Missing (%)	14.0%
Memory size	4.5 MiB

30-06-2017	5104
31-10-2017	4985
30-09-2017	4928
31-08-2017	4914
31-05-2017	4882
Other values (3525)	481149

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	5059620
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	325 ?
Unique (%)	0.1%

Sample

1st row	01-10-2009
2nd row	01-10-2009
3rd row	01-11-2009
4th row	01-10-2009
5th row	01-10-2009

Common Values

Value	Count	Frequency (%)
30-06-2017	5104	0.9%
31-10-2017	4985	0.8%
30-09-2017	4928	0.8%
31-08-2017	4914	0.8%
31-05-2017	4882	0.8%
31-03-2018	4715	0.8%
31-05-2018	4622	0.8%
31-12-2017	4547	0.8%
30-06-2018	4529	0.8%
31-08-2018	4504	0.8%
Other values (3520)	458232	77.9%
(Missing)	82091	14.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
30-06-2017	5104	1.0%
31-10-2017	4985	1.0%
30-09-2017	4928	1.0%
31-08-2017	4914	1.0%
31-05-2017	4882	1.0%
31-03-2018	4715	0.9%
31-05-2018	4622	0.9%
31-12-2017	4547	0.9%
30-06-2018	4529	0.9%
31-08-2018	4504	0.9%
Other values (3520)	458232	90.6%

Most occurring characters

Value	Count	Frequency (%)
0	1323670	26.2%
1	1088211	21.5%
-	1011924	20.0%
2	709020	14.0%
3	250031	4.9%
8	118551	2.3%
6	116900	2.3%
7	113866	2.3%
5	112864	2.2%
9	108870	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4047696	80.0%
Dash Punctuation	1011924	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1323670	32.7%
1	1088211	26.9%
2	709020	17.5%
3	250031	6.2%
8	118551	2.9%
6	116900	2.9%
7	113866	2.8%
5	112864	2.8%
9	108870	2.7%
4	105713	2.6%

Dash Punctuation

Value	Count	Frequency (%)
-	1011924	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5059620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1323670	26.2%
1	1088211	21.5%
-	1011924	20.0%
2	709020	14.0%
3	250031	4.9%
8	118551	2.3%
6	116900	2.3%
7	113866	2.3%
5	112864	2.2%
9	108870	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5059620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1323670	26.2%
1	1088211	21.5%
-	1011924	20.0%
2	709020	14.0%
3	250031	4.9%
8	118551	2.3%
6	116900	2.3%
7	113866	2.3%
5	112864	2.2%
9	108870	2.2%

DeliveryMethod
Categorical

HIGH CORRELATION IMBALANCE

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

SBA EXPRES	280906
PLP	195338
OTH 7A	49625
SLA	31522
CA	6390
Other values (10)	24272

Length

Max length	10
Median length	10
Mean length	6.780814
Min length	2

Characters and Unicode

Total characters	3987478
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SBA EXPRES
2nd row	PLP
3rd row	PLP
4th row	SBA EXPRES
5th row	COMM EXPRS

Common Values

Value	Count	Frequency (%)
SBA EXPRES	280906	47.8%
PLP	195338	33.2%
OTH 7A	49625	8.4%
SLA	31522	5.4%
CA	6390	1.1%
PATRIOT EX	6247	1.1%
COMM EXPRS	5468	0.9%
RLA	3096	0.5%
CLP	2653	0.5%
EWCP	1798	0.3%
Other values (5)	5010	0.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
expres	282362	30.2%
sba	280906	30.0%
plp	195338	20.9%
oth	49625	5.3%
7a	49625	5.3%
sla	31522	3.4%
ca	6390	0.7%
patriot	6247	0.7%
ex	6247	0.7%
exprs	5468	0.6%
Other values (11)	21443	2.3%

Most occurring characters

Value	Count	Frequency (%)
P	690785	17.3%
S	601978	15.1%
E	583100	14.6%
A	379506	9.5%
	347120	8.7%
R	300569	7.5%
X	295544	7.4%
B	280906	7.0%
L	234329	5.9%
T	65515	1.6%
Other values (11)	208126	5.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3590733	90.1%
Space Separator	347120	8.7%
Decimal Number	49625	1.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	690785	19.2%
S	601978	16.8%
E	583100	16.2%
A	379506	10.6%
R	300569	8.4%
X	295544	8.2%
B	280906	7.8%
L	234329	6.5%
T	65515	1.8%
O	64780	1.8%
Other values (9)	93721	2.6%

Space Separator

Value	Count	Frequency (%)
	347120	100.0%

Decimal Number

Value	Count	Frequency (%)
7	49625	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3590733	90.1%
Common	396745	9.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	690785	19.2%
S	601978	16.8%
E	583100	16.2%
A	379506	10.6%
R	300569	8.4%
X	295544	8.2%
B	280906	7.8%
L	234329	6.5%
T	65515	1.8%
O	64780	1.8%
Other values (9)	93721	2.6%

Common

Value	Count	Frequency (%)
	347120	87.5%
7	49625	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3987478	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	690785	17.3%
S	601978	15.1%
E	583100	14.6%
A	379506	9.5%
	347120	8.7%
R	300569	7.5%
X	295544	7.4%
B	280906	7.0%
L	234329	5.9%
T	65515	1.6%
Other values (11)	208126	5.2%

subpgmdesc
Categorical

HIGH CORRELATION IMBALANCE

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

FA$TRK (Small Loan Express)	282368
Guaranty	243090
Lender Advantage Initiative	31521
Community Advantage Initiative	6457
Patriot Express	6247
Other values (12)	18370

Length

Max length	49
Median length	27
Mean length	18.942708
Min length	8

Characters and Unicode

Total characters	11139316
Distinct characters	53
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FA$TRK (Small Loan Express)
2nd row	Guaranty
3rd row	Guaranty
4th row	FA$TRK (Small Loan Express)
5th row	Community Express

Common Values

Value	Count	Frequency (%)
FA$TRK (Small Loan Express)	282368	48.0%
Guaranty	243090	41.3%
Lender Advantage Initiative	31521	5.4%
Community Advantage Initiative	6457	1.1%
Patriot Express	6247	1.1%
Community Express	5468	0.9%
Standard Asset Based	3394	0.6%
Rural Lender Advantage	3096	0.5%
Revolving Line of Credit Exports - Sec. 7(a) (14)	1800	0.3%
Gulf Opportunity	1720	0.3%
Other values (7)	2892	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
express	294083	18.8%
small	282571	18.1%
fa$trk	282368	18.1%
loan	282368	18.1%
guaranty	243703	15.6%
advantage	41074	2.6%
initiative	37978	2.4%
lender	34617	2.2%
community	11925	0.8%
patriot	6247	0.4%
Other values (30)	46379	3.0%

Most occurring characters

Value	Count	Frequency (%)
a	1202206	10.8%
	975260	8.8%
n	666884	6.0%
s	600685	5.4%
r	595180	5.3%
l	573853	5.2%
e	462738	4.2%
t	404206	3.6%
A	327156	2.9%
L	319398	2.9%
Other values (43)	5011750	45.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6602426	59.3%
Uppercase Letter	2681268	24.1%
Space Separator	975260	8.8%
Open Punctuation	289682	2.6%
Close Punctuation	289682	2.6%
Currency Symbol	282368	2.5%
Decimal Number	11191	0.1%
Dash Punctuation	3782	< 0.1%
Other Punctuation	3657	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	327156	12.2%
L	319398	11.9%
E	296144	11.0%
S	289860	10.8%
R	287547	10.7%
T	284103	10.6%
F	282493	10.5%
K	282368	10.5%
G	245578	9.2%
I	39713	1.5%
Other values (10)	26908	1.0%

Lowercase Letter

Value	Count	Frequency (%)
a	1202206	18.2%
n	666884	10.1%
s	600685	9.1%
r	595180	9.0%
l	573853	8.7%
e	462738	7.0%
t	404206	6.1%
o	310761	4.7%
m	306421	4.6%
p	299323	4.5%
Other values (9)	1180169	17.9%

Decimal Number

Value	Count	Frequency (%)
7	3657	32.7%
1	3502	31.3%
4	1800	16.1%
6	1702	15.2%
9	280	2.5%
5	125	1.1%
0	125	1.1%

Other Punctuation

Value	Count	Frequency (%)
.	1955	53.5%
,	1702	46.5%

Space Separator

Value	Count	Frequency (%)
	975260	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	289682	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	289682	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	282368	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3782	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9283694	83.3%
Common	1855622	16.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1202206	12.9%
n	666884	7.2%
s	600685	6.5%
r	595180	6.4%
l	573853	6.2%
e	462738	5.0%
t	404206	4.4%
A	327156	3.5%
L	319398	3.4%
o	310761	3.3%
Other values (29)	3820627	41.2%

Common

Value	Count	Frequency (%)
	975260	52.6%
(	289682	15.6%
)	289682	15.6%
$	282368	15.2%
-	3782	0.2%
7	3657	0.2%
1	3502	0.2%
.	1955	0.1%
4	1800	0.1%
,	1702	0.1%
Other values (4)	2232	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11139316	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1202206	10.8%
	975260	8.8%
n	666884	6.0%
s	600685	5.4%
r	595180	5.3%
l	573853	5.2%
e	462738	4.2%
t	404206	3.6%
A	327156	2.9%
L	319398	2.9%
Other values (43)	5011750	45.0%

InitialInterestRate
Real number (ℝ)

Distinct	1869
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	6.5260795

Minimum	0
Maximum	13.5
Zeros	21
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	4.5
Q1	5.5
median	6
Q3	7.5
95-th percentile	9.75
Maximum	13.5
Range	13.5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5680676
Coefficient of variation (CV)	0.24027712
Kurtosis	0.80181718
Mean	6.5260795
Median Absolute Deviation (MAD)	0.75
Skewness	0.83206164
Sum	3837674.1
Variance	2.458836
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	88470	15.0%
5.5	38324	6.5%
5.25	35171	6.0%
5.75	31785	5.4%
6.25	28211	4.8%
7	22706	3.9%
6.5	21248	3.6%
7.75	19919	3.4%
5	19804	3.4%
7.5	17968	3.1%
Other values (1859)	264446	45.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21	< 0.1%
0.5	3	< 0.1%
0.66	1	< 0.1%
0.75	7	< 0.1%
0.85	1	< 0.1%
1	71	< 0.1%
1.01	1	< 0.1%
1.16	1	< 0.1%
1.2	1	< 0.1%
1.24	1	< 0.1%

Value	Count	Frequency (%)
13.5	2	< 0.1%
13.25	3	< 0.1%
12.99	12	< 0.1%
12.75	3	< 0.1%
12.74	2	< 0.1%
12.5	3	< 0.1%
12.493	1	< 0.1%
12.49	4	< 0.1%
12.25	2	< 0.1%
12.24	4	< 0.1%

TermInMonths
Real number (ℝ)

Distinct	335
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	123.53789

Minimum	0
Maximum	847
Zeros	109
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	36
Q1	84
median	91
Q3	120
95-th percentile	300
Maximum	847
Range	847
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	79.111359
Coefficient of variation (CV)	0.64038136
Kurtosis	0.69057441
Mean	123.53789
Median Absolute Deviation (MAD)	29
Skewness	1.3370841
Sum	72646824
Variance	6258.6071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
84	158893	27.0%
120	150221	25.5%
300	65482	11.1%
60	59789	10.2%
240	12754	2.2%
180	8711	1.5%
36	8429	1.4%
12	6489	1.1%
48	6405	1.1%
72	5965	1.0%
Other values (325)	104915	17.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	109	< 0.1%
1	182	< 0.1%
2	251	< 0.1%
3	324	0.1%
4	304	0.1%
5	269	< 0.1%
6	544	0.1%
7	277	< 0.1%
8	248	< 0.1%
9	260	< 0.1%

Value	Count	Frequency (%)
847	1	< 0.1%
720	2	< 0.1%
400	1	< 0.1%
360	4	< 0.1%
352	1	< 0.1%
345	1	< 0.1%
343	1	< 0.1%
332	1	< 0.1%
328	2	< 0.1%
326	2	< 0.1%

NaicsCode
Real number (ℝ)

Distinct	1256
Distinct (%)	0.2%
Missing	12
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	523739.05

Minimum	111110
Maximum	928120
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	111110
5-th percentile	237310
Q1	424930
median	541110
Q3	624410
95-th percentile	812111
Maximum	928120
Range	817010
Interquartile range (IQR)	199480

Descriptive statistics

Standard deviation	175451.23
Coefficient of variation (CV)	0.33499742
Kurtosis	-0.69789387
Mean	523739.05
Median Absolute Deviation (MAD)	116120
Skewness	-0.17036997
Sum	3.0798004 × 10¹¹
Variance	3.0783134 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
722511	22534	3.8%
722513	14979	2.5%
621210	11244	1.9%
484121	9798	1.7%
721110	9453	1.6%
713940	9149	1.6%
621111	8618	1.5%
561730	8461	1.4%
811111	8363	1.4%
238990	8341	1.4%
Other values (1246)	477101	81.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
111110	81	< 0.1%
111120	5	< 0.1%
111130	1	< 0.1%
111140	17	< 0.1%
111150	51	< 0.1%
111160	1	< 0.1%
111191	19	< 0.1%
111199	45	< 0.1%
111211	23	< 0.1%
111219	103	< 0.1%

Value	Count	Frequency (%)
928120	2	< 0.1%
926150	9	< 0.1%
926140	1	< 0.1%
926130	3	< 0.1%
926120	2	< 0.1%
926110	3	< 0.1%
925120	1	< 0.1%
924120	1	< 0.1%
924110	11	< 0.1%
923130	7	< 0.1%

NaicsDescription
Categorical

Distinct	1220
Distinct (%)	0.2%
Missing	742
Missing (%)	0.1%
Memory size	4.5 MiB

Full-Service Restaurants	30672
Limited-Service Restaurants	20473
Offices of Dentists	11244
General Freight Trucking, Long Distance, Truckload	9798
Hotels (except Casino Hotels) and Motels	9453
Other values (1215)	505671

Length

Max length	70
Median length	57
Mean length	34.014634
Min length	7

Characters and Unicode

Total characters	19977169
Distinct characters	59
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	51 ?
Unique (%)	< 0.1%

Sample

1st row	Offices of Real Estate Agents and Brokers
2nd row	Drinking Places (Alcoholic Beverages)
3rd row	Car Washes
4th row	Commercial Lithographic Printing
5th row	Automotive Body, Paint, and Interior Repair and Maintenance

Common Values

Value	Count	Frequency (%)
Full-Service Restaurants	30672	5.2%
Limited-Service Restaurants	20473	3.5%
Offices of Dentists	11244	1.9%
General Freight Trucking, Long Distance, Truckload	9798	1.7%
Hotels (except Casino Hotels) and Motels	9453	1.6%
Fitness and Recreational Sports Centers	9149	1.6%
Offices of Physicians (except Mental Health Specialists)	8618	1.5%
Landscaping Services	8461	1.4%
General Automotive Repair	8363	1.4%
All Other Specialty Trade Contractors	8341	1.4%
Other values (1210)	462739	78.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	213787	8.7%
other	101785	4.1%
services	97409	4.0%
stores	63473	2.6%
of	55282	2.2%
restaurants	51145	2.1%
offices	49218	2.0%
except	48580	2.0%
all	46729	1.9%
contractors	44293	1.8%
Other values (1488)	1693893	68.7%

Most occurring characters

Value	Count	Frequency (%)
e	2120751	10.6%
	1878283	9.4%
r	1379836	6.9%
a	1323156	6.6%
t	1321203	6.6%
n	1310268	6.6%
i	1308803	6.6%
s	1140870	5.7%
o	1013258	5.1%
c	833558	4.2%
Other values (49)	6347183	31.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15581319	78.0%
Uppercase Letter	2198173	11.0%
Space Separator	1878283	9.4%
Other Punctuation	136706	0.7%
Dash Punctuation	73925	0.4%
Open Punctuation	55555	0.3%
Close Punctuation	53208	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2120751	13.6%
r	1379836	8.9%
a	1323156	8.5%
t	1321203	8.5%
n	1310268	8.4%
i	1308803	8.4%
s	1140870	7.3%
o	1013258	6.5%
c	833558	5.3%
l	820516	5.3%
Other values (16)	3009100	19.3%

Uppercase Letter

Value	Count	Frequency (%)
S	378889	17.2%
C	238286	10.8%
O	176894	8.0%
M	174836	8.0%
A	142700	6.5%
R	137357	6.2%
P	134828	6.1%
F	110242	5.0%
L	89686	4.1%
T	85211	3.9%
Other values (15)	529244	24.1%

Other Punctuation

Value	Count	Frequency (%)
,	127879	93.5%
'	8213	6.0%
¿	578	0.4%
/	36	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1878283	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	73925	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	55555	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	53208	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17779492	89.0%
Common	2197677	11.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2120751	11.9%
r	1379836	7.8%
a	1323156	7.4%
t	1321203	7.4%
n	1310268	7.4%
i	1308803	7.4%
s	1140870	6.4%
o	1013258	5.7%
c	833558	4.7%
l	820516	4.6%
Other values (41)	5207273	29.3%

Common

Value	Count	Frequency (%)
	1878283	85.5%
,	127879	5.8%
-	73925	3.4%
(	55555	2.5%
)	53208	2.4%
'	8213	0.4%
¿	578	< 0.1%
/	36	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19976591	> 99.9%
None	578	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2120751	10.6%
	1878283	9.4%
r	1379836	6.9%
a	1323156	6.6%
t	1321203	6.6%
n	1310268	6.6%
i	1308803	6.6%
s	1140870	5.7%
o	1013258	5.1%
c	833558	4.2%
Other values (48)	6346605	31.8%

None

Value	Count	Frequency (%)
¿	578	100.0%

FranchiseCode
Categorical

HIGH CARDINALITY MISSING

Distinct	5444
Distinct (%)	10.2%
Missing	534676
Missing (%)	90.9%
Memory size	4.5 MiB

13680	650
78760	649
10245	407
11965	393
13913	351
Other values (5439)	50927

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	266885
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1816 ?
Unique (%)	3.4%

Sample

1st row	03512
2nd row	06560
3rd row	79140
4th row	04154
5th row	70552

Common Values

Value	Count	Frequency (%)
13680	650	0.1%
78760	649	0.1%
10245	407	0.1%
11965	393	0.1%
13913	351	0.1%
13593	322	0.1%
12645	306	0.1%
13058	299	0.1%
S1639	297	0.1%
S0122	256	< 0.1%
Other values (5434)	49447	8.4%
(Missing)	534676	90.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
13680	650	1.2%
78760	649	1.2%
10245	407	0.8%
11965	393	0.7%
13913	351	0.7%
13593	322	0.6%
12645	306	0.6%
13058	299	0.6%
s1639	298	0.6%
s0122	257	0.5%
Other values (5372)	49445	92.6%

Most occurring characters

Value	Count	Frequency (%)
1	54931	20.6%
0	32727	12.3%
3	25257	9.5%
2	25146	9.4%
5	21962	8.2%
4	19836	7.4%
S	18548	6.9%
9	17809	6.7%
6	17231	6.5%
7	17216	6.5%
Other values (2)	16222	6.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	248258	93.0%
Uppercase Letter	18548	6.9%
Lowercase Letter	79	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	54931	22.1%
0	32727	13.2%
3	25257	10.2%
2	25146	10.1%
5	21962	8.8%
4	19836	8.0%
9	17809	7.2%
6	17231	6.9%
7	17216	6.9%
8	16143	6.5%

Uppercase Letter

Value	Count	Frequency (%)
S	18548	100.0%

Lowercase Letter

Value	Count	Frequency (%)
s	79	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	248258	93.0%
Latin	18627	7.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	54931	22.1%
0	32727	13.2%
3	25257	10.2%
2	25146	10.1%
5	21962	8.8%
4	19836	8.0%
9	17809	7.2%
6	17231	6.9%
7	17216	6.9%
8	16143	6.5%

Latin

Value	Count	Frequency (%)
S	18548	99.6%
s	79	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	266885	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	54931	20.6%
0	32727	12.3%
3	25257	9.5%
2	25146	9.4%
5	21962	8.2%
4	19836	7.4%
S	18548	6.9%
9	17809	6.7%
6	17231	6.5%
7	17216	6.5%
Other values (2)	16222	6.1%

FranchiseName
Categorical

HIGH CARDINALITY MISSING

Distinct	4768
Distinct (%)	9.0%
Missing	534790
Missing (%)	90.9%
Memory size	4.5 MiB

SUBWAY	650
SUBWAY SANDWICH SHOP	649
JIMMY JOHN'S	593
ANYTIME FITNESS	571
THE UPS STORE	432
Other values (4763)	50368

Length

Max length	30
Median length	23
Mean length	16.085857
Min length	3

Characters and Unicode

Total characters	856781
Distinct characters	86
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1478 ?
Unique (%)	2.8%

Sample

1st row	ALPHAGRAPHICS, PRINTSHOPS OF T
2nd row	AUNTIE ANN'S (SOFT PRETZELS)
3rd row	SUPER 8 MOTEL
4th row	AMERIPRISE FINANCIAL SERVICES
5th row	RODEWAY INNS

Common Values

Value	Count	Frequency (%)
SUBWAY	650	0.1%
SUBWAY SANDWICH SHOP	649	0.1%
JIMMY JOHN'S	593	0.1%
ANYTIME FITNESS	571	0.1%
THE UPS STORE	432	0.1%
FIREHOUSE SUBS	363	0.1%
DAYS INN	327	0.1%
SPORT CLIPS	322	0.1%
MASSAGE ENVY	312	0.1%
ORANGE THEORY FITNESS	306	0.1%
Other values (4758)	48738	8.3%
(Missing)	534790	90.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inn	2851	2.1%
the	2804	2.1%
	2672	2.0%
pizza	2060	1.5%
fitness	1839	1.4%
subway	1596	1.2%
suites	1152	0.9%
shop	879	0.7%
john's	871	0.7%
anytime	860	0.6%
Other values (4597)	116304	86.9%

Most occurring characters

Value	Count	Frequency (%)
	80516	9.4%
E	51306	6.0%
S	49245	5.7%
A	42850	5.0%
I	39561	4.6%
T	35445	4.1%
N	34652	4.0%
R	34419	4.0%
O	32337	3.8%
e	28794	3.4%
Other values (76)	427656	49.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	527563	61.6%
Lowercase Letter	225274	26.3%
Space Separator	80851	9.4%
Other Punctuation	14287	1.7%
Decimal Number	3640	0.4%
Dash Punctuation	2651	0.3%
Open Punctuation	1525	0.2%
Close Punctuation	847	0.1%
Math Symbol	133	< 0.1%
Other Symbol	8	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	28794	12.8%
a	20307	9.0%
r	19462	8.6%
i	18668	8.3%
o	18616	8.3%
n	17930	8.0%
t	15067	6.7%
s	14487	6.4%
l	10386	4.6%
u	8246	3.7%
Other values (18)	53311	23.7%

Uppercase Letter

Value	Count	Frequency (%)
E	51306	9.7%
S	49245	9.3%
A	42850	8.1%
I	39561	7.5%
T	35445	6.7%
N	34652	6.6%
R	34419	6.5%
O	32337	6.1%
C	25876	4.9%
L	20320	3.9%
Other values (17)	161552	30.6%

Other Punctuation

Value	Count	Frequency (%)
'	7020	49.1%
/	2232	15.6%
&	2156	15.1%
.	1906	13.3%
,	772	5.4%
!	135	0.9%
¿	30	0.2%
?	23	0.2%
#	8	0.1%
%	3	< 0.1%
Other values (2)	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
8	747	20.5%
1	640	17.6%
6	610	16.8%
0	452	12.4%
4	281	7.7%
5	232	6.4%
2	209	5.7%
3	205	5.6%
9	170	4.7%
7	94	2.6%

Space Separator

Value	Count	Frequency (%)
	80516	99.6%
	335	0.4%

Math Symbol

Value	Count	Frequency (%)
+	127	95.5%
=	6	4.5%

Dash Punctuation

Value	Count	Frequency (%)
-	2651	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1525	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	847	100.0%

Other Symbol

Value	Count	Frequency (%)
®	8	100.0%

Other Number

Value	Count	Frequency (%)
²	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	752837	87.9%
Common	103944	12.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	51306	6.8%
S	49245	6.5%
A	42850	5.7%
I	39561	5.3%
T	35445	4.7%
N	34652	4.6%
R	34419	4.6%
O	32337	4.3%
e	28794	3.8%
C	25876	3.4%
Other values (45)	378352	50.3%

Common

Value	Count	Frequency (%)
	80516	77.5%
'	7020	6.8%
-	2651	2.6%
/	2232	2.1%
&	2156	2.1%
.	1906	1.8%
(	1525	1.5%
)	847	0.8%
,	772	0.7%
8	747	0.7%
Other values (21)	3572	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	856378	> 99.9%
None	403	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	80516	9.4%
E	51306	6.0%
S	49245	5.8%
A	42850	5.0%
I	39561	4.6%
T	35445	4.1%
N	34652	4.0%
R	34419	4.0%
O	32337	3.8%
e	28794	3.4%
Other values (68)	427253	49.9%

None

Value	Count	Frequency (%)
	335	83.1%
¿	30	7.4%
é	12	3.0%
É	9	2.2%
®	8	2.0%
ö	6	1.5%
²	2	0.5%
·	1	0.2%

ProjectCounty
Categorical

Distinct	1889
Distinct (%)	0.3%
Missing	2
Missing (%)	< 0.1%
Memory size	4.5 MiB

LOS ANGELES	22751
ORANGE	11133
COOK	8888
MARICOPA	8474
HARRIS	8340
Other values (1884)	528465

Length

Max length	25
Median length	20
Mean length	7.511607
Min length	3

Characters and Unicode

Total characters	4417208
Distinct characters	32
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	54 ?
Unique (%)	< 0.1%

Sample

1st row	DENVER
2nd row	SACRAMENTO
3rd row	YOLO
4th row	FAIRFIELD
5th row	ELKHART

Common Values

Value	Count	Frequency (%)
LOS ANGELES	22751	3.9%
ORANGE	11133	1.9%
COOK	8888	1.5%
MARICOPA	8474	1.4%
HARRIS	8340	1.4%
SAN DIEGO	6883	1.2%
MONTGOMERY	6784	1.2%
MIDDLESEX	6654	1.1%
FRANKLIN	6222	1.1%
JEFFERSON	6099	1.0%
Other values (1879)	495823	84.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
los	22764	3.3%
angeles	22751	3.3%
san	16887	2.5%
orange	11133	1.6%
cook	8888	1.3%
maricopa	8474	1.2%
harris	8340	1.2%
new	8154	1.2%
lake	7858	1.2%
diego	6883	1.0%
Other values (1907)	559221	82.1%

Most occurring characters

Value	Count	Frequency (%)
A	513339	11.6%
E	434906	9.8%
N	386797	8.8%
O	364196	8.2%
R	296063	6.7%
S	290357	6.6%
L	290334	6.6%
I	241762	5.5%
T	180178	4.1%
M	150406	3.4%
Other values (22)	1268870	28.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4319180	97.8%
Space Separator	93302	2.1%
Dash Punctuation	4711	0.1%
Lowercase Letter	15	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	513339	11.9%
E	434906	10.1%
N	386797	9.0%
O	364196	8.4%
R	296063	6.9%
S	290357	6.7%
L	290334	6.7%
I	241762	5.6%
T	180178	4.2%
M	150406	3.5%
Other values (16)	1170842	27.1%

Lowercase Letter

Value	Count	Frequency (%)
a	6	40.0%
i	3	20.0%
p	3	20.0%
n	3	20.0%

Space Separator

Value	Count	Frequency (%)
	93302	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4711	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4319195	97.8%
Common	98013	2.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	513339	11.9%
E	434906	10.1%
N	386797	9.0%
O	364196	8.4%
R	296063	6.9%
S	290357	6.7%
L	290334	6.7%
I	241762	5.6%
T	180178	4.2%
M	150406	3.5%
Other values (20)	1170857	27.1%

Common

Value	Count	Frequency (%)
	93302	95.2%
-	4711	4.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4417208	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	513339	11.6%
E	434906	9.8%
N	386797	8.8%
O	364196	8.2%
R	296063	6.7%
S	290357	6.6%
L	290334	6.6%
I	241762	5.5%
T	180178	4.1%
M	150406	3.4%
Other values (22)	1268870	28.7%

ProjectState
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	58
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

CA	73437
TX	44815
NY	37465
OH	33473
FL	28650
Other values (53)	370213

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1176106
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	CO
2nd row	CA
3rd row	CA
4th row	CT
5th row	IN

Common Values

Value	Count	Frequency (%)
CA	73437	12.5%
TX	44815	7.6%
NY	37465	6.4%
OH	33473	5.7%
FL	28650	4.9%
MI	22983	3.9%
MA	20765	3.5%
IL	19460	3.3%
PA	18831	3.2%
MN	16980	2.9%
Other values (48)	271194	46.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	73437	12.5%
tx	44815	7.6%
ny	37465	6.4%
oh	33473	5.7%
fl	28650	4.9%
mi	22983	3.9%
ma	20765	3.5%
il	19460	3.3%
pa	18831	3.2%
mn	16980	2.9%
Other values (48)	271194	46.1%

Most occurring characters

Value	Count	Frequency (%)
A	183962	15.6%
N	119602	10.2%
C	111818	9.5%
M	94427	8.0%
I	87963	7.5%
T	74075	6.3%
O	72675	6.2%
L	56877	4.8%
X	44815	3.8%
Y	43966	3.7%
Other values (14)	285926	24.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1176106	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	183962	15.6%
N	119602	10.2%
C	111818	9.5%
M	94427	8.0%
I	87963	7.5%
T	74075	6.3%
O	72675	6.2%
L	56877	4.8%
X	44815	3.8%
Y	43966	3.7%
Other values (14)	285926	24.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1176106	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	183962	15.6%
N	119602	10.2%
C	111818	9.5%
M	94427	8.0%
I	87963	7.5%
T	74075	6.3%
O	72675	6.2%
L	56877	4.8%
X	44815	3.8%
Y	43966	3.7%
Other values (14)	285926	24.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1176106	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	183962	15.6%
N	119602	10.2%
C	111818	9.5%
M	94427	8.0%
I	87963	7.5%
T	74075	6.3%
O	72675	6.2%
L	56877	4.8%
X	44815	3.8%
Y	43966	3.7%
Other values (14)	285926	24.3%

SBADistrictOffice
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	74
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

LOS ANGELES DISTRICT OFFICE	24831
MICHIGAN DISTRICT OFFICE	22982
SOUTH FLORIDA DISTRICT OFFICE	20482
ILLINOIS DISTRICT OFFICE	19458
MASSACHUSETTS DISTRICT OFFICE	18941
Other values (69)	481359

Length

Max length	40
Median length	34
Mean length	26.511124
Min length	21

Characters and Unicode

Total characters	15589946
Distinct characters	29
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	COLORADO DISTRICT OFFICE
2nd row	SACRAMENTO DISTRICT OFFICE
3rd row	SACRAMENTO DISTRICT OFFICE
4th row	CONNECTICUT DISTRICT OFFICE
5th row	INDIANA DISTRICT OFFICE

Common Values

Value	Count	Frequency (%)
LOS ANGELES DISTRICT OFFICE	24831	4.2%
MICHIGAN DISTRICT OFFICE	22982	3.9%
SOUTH FLORIDA DISTRICT OFFICE	20482	3.5%
ILLINOIS DISTRICT OFFICE	19458	3.3%
MASSACHUSETTS DISTRICT OFFICE	18941	3.2%
DALLAS / FT WORTH DISTRICT OFFICE	17796	3.0%
NEW YORK DISTRICT OFFICE	17516	3.0%
MINNESOTA DISTRICT OFFICE	16980	2.9%
COLUMBUS DISTRICT OFFICE	16979	2.9%
CLEVELAND DISTRICT OFFICE	16495	2.8%
Other values (64)	395593	67.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
office	588053	29.1%
district	567133	28.1%
new	42164	2.1%
san	29532	1.5%
florida	28650	1.4%
south	26615	1.3%
los	24831	1.2%
angeles	24831	1.2%
michigan	22982	1.1%
north	21896	1.1%
Other values (86)	642812	31.8%

Most occurring characters

Value	Count	Frequency (%)
I	2168720	13.9%
T	1440496	9.2%
	1431446	9.2%
C	1392928	8.9%
F	1255506	8.1%
S	1069339	6.9%
O	1067809	6.8%
E	981484	6.3%
R	863488	5.5%
D	729117	4.7%
Other values (19)	3189613	20.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	13547678	86.9%
Space Separator	2019499	13.0%
Other Punctuation	22769	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	2168720	16.0%
T	1440496	10.6%
C	1392928	10.3%
F	1255506	9.3%
S	1069339	7.9%
O	1067809	7.9%
E	981484	7.2%
R	863488	6.4%
D	729117	5.4%
A	664280	4.9%
Other values (15)	1914511	14.1%

Space Separator

Value	Count	Frequency (%)
	1431446	70.9%
	588053	29.1%

Other Punctuation

Value	Count	Frequency (%)
/	17796	78.2%
.	4973	21.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13547678	86.9%
Common	2042268	13.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	2168720	16.0%
T	1440496	10.6%
C	1392928	10.3%
F	1255506	9.3%
S	1069339	7.9%
O	1067809	7.9%
E	981484	7.2%
R	863488	6.4%
D	729117	5.4%
A	664280	4.9%
Other values (15)	1914511	14.1%

Common

Value	Count	Frequency (%)
	1431446	70.1%
	588053	28.8%
/	17796	0.9%
.	4973	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15001893	96.2%
None	588053	3.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	2168720	14.5%
T	1440496	9.6%
	1431446	9.5%
C	1392928	9.3%
F	1255506	8.4%
S	1069339	7.1%
O	1067809	7.1%
E	981484	6.5%
R	863488	5.8%
D	729117	4.9%
Other values (18)	2601560	17.3%

None

Value	Count	Frequency (%)
	588053	100.0%

CongressionalDistrict
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	54
Distinct (%)	< 0.1%
Missing	35
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	10.241255

Minimum	0
Maximum	53
Zeros	19793
Zeros (%)	3.4%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	6
Q3	13
95-th percentile	35
Maximum	53
Range	53
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	11.014161
Coefficient of variation (CV)	1.0754699
Kurtosis	2.9598985
Mean	10.241255
Median Absolute Deviation (MAD)	4
Skewness	1.7992169
Sum	6022042
Variance	121.31173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	58261	9.9%
2	55536	9.4%
3	49998	8.5%
4	43294	7.4%
6	36697	6.2%
5	36671	6.2%
7	35706	6.1%
8	26399	4.5%
9	22340	3.8%
0	19793	3.4%
Other values (44)	203323	34.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19793	3.4%
1	58261	9.9%
2	55536	9.4%
3	49998	8.5%
4	43294	7.4%
5	36671	6.2%
6	36697	6.2%
7	35706	6.1%
8	26399	4.5%
9	22340	3.8%

Value	Count	Frequency (%)
53	1593	0.3%
52	1977	0.3%
51	974	0.2%
50	1051	0.2%
49	1977	0.3%
48	1703	0.3%
47	1539	0.3%
46	1506	0.3%
45	2374	0.4%
44	1241	0.2%

BusinessType
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Memory size	4.5 MiB

CORPORATION	516179
INDIVIDUAL	61455
PARTNERSHIP	10414

Length

Max length	11
Median length	11
Mean length	10.895493
Min length	10

Characters and Unicode

Total characters	6407073
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CORPORATION
2nd row	CORPORATION
3rd row	CORPORATION
4th row	CORPORATION
5th row	INDIVIDUAL

Common Values

Value	Count	Frequency (%)
CORPORATION	516179	87.8%
INDIVIDUAL	61455	10.5%
PARTNERSHIP	10414	1.8%
(Missing)	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
corporation	516179	87.8%
individual	61455	10.5%
partnership	10414	1.8%

Most occurring characters

Value	Count	Frequency (%)
O	1548537	24.2%
R	1053186	16.4%
I	710958	11.1%
A	588048	9.2%
N	588048	9.2%
P	537007	8.4%
T	526593	8.2%
C	516179	8.1%
D	122910	1.9%
V	61455	1.0%
Other values (5)	154152	2.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6407073	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	1548537	24.2%
R	1053186	16.4%
I	710958	11.1%
A	588048	9.2%
N	588048	9.2%
P	537007	8.4%
T	526593	8.2%
C	516179	8.1%
D	122910	1.9%
V	61455	1.0%
Other values (5)	154152	2.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6407073	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	1548537	24.2%
R	1053186	16.4%
I	710958	11.1%
A	588048	9.2%
N	588048	9.2%
P	537007	8.4%
T	526593	8.2%
C	516179	8.1%
D	122910	1.9%
V	61455	1.0%
Other values (5)	154152	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6407073	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	1548537	24.2%
R	1053186	16.4%
I	710958	11.1%
A	588048	9.2%
N	588048	9.2%
P	537007	8.4%
T	526593	8.2%
C	516179	8.1%
D	122910	1.9%
V	61455	1.0%
Other values (5)	154152	2.4%

LoanStatus
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

EXEMPT	262008
PIF	222841
CANCLD	66739
CHGOFF	20670
COMMIT	15795

Length

Max length	6
Median length	6
Mean length	4.8631586
Min length	3

Characters and Unicode

Total characters	2859795
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PIF
2nd row	PIF
3rd row	CHGOFF
4th row	EXEMPT
5th row	PIF

Common Values

Value	Count	Frequency (%)
EXEMPT	262008	44.6%
PIF	222841	37.9%
CANCLD	66739	11.3%
CHGOFF	20670	3.5%
COMMIT	15795	2.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
exempt	262008	44.6%
pif	222841	37.9%
cancld	66739	11.3%
chgoff	20670	3.5%
commit	15795	2.7%

Most occurring characters

Value	Count	Frequency (%)
E	524016	18.3%
P	484849	17.0%
M	293598	10.3%
T	277803	9.7%
F	264181	9.2%
X	262008	9.2%
I	238636	8.3%
C	169943	5.9%
A	66739	2.3%
N	66739	2.3%
Other values (5)	211283	7.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2859795	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	524016	18.3%
P	484849	17.0%
M	293598	10.3%
T	277803	9.7%
F	264181	9.2%
X	262008	9.2%
I	238636	8.3%
C	169943	5.9%
A	66739	2.3%
N	66739	2.3%
Other values (5)	211283	7.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2859795	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	524016	18.3%
P	484849	17.0%
M	293598	10.3%
T	277803	9.7%
F	264181	9.2%
X	262008	9.2%
I	238636	8.3%
C	169943	5.9%
A	66739	2.3%
N	66739	2.3%
Other values (5)	211283	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2859795	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	524016	18.3%
P	484849	17.0%
M	293598	10.3%
T	277803	9.7%
F	264181	9.2%
X	262008	9.2%
I	238636	8.3%
C	169943	5.9%
A	66739	2.3%
N	66739	2.3%
Other values (5)	211283	7.4%

PaidInFullDate
Categorical

HIGH CARDINALITY MISSING

Distinct	130
Distinct (%)	0.1%
Missing	365212
Missing (%)	62.1%
Memory size	4.5 MiB

31-10-2019	3819
31-12-2019	3779
30-04-2019	3604
31-12-2017	3516
31-08-2019	3484
Other values (125)	204639

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	2228410
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	31-10-2016
2nd row	31-03-2019
3rd row	28-02-2013
4th row	31-10-2019
5th row	31-03-2017

Common Values

Value	Count	Frequency (%)
31-10-2019	3819	0.6%
31-12-2019	3779	0.6%
30-04-2019	3604	0.6%
31-12-2017	3516	0.6%
31-08-2019	3484	0.6%
30-09-2019	3444	0.6%
31-08-2018	3440	0.6%
31-05-2019	3430	0.6%
31-03-2019	3413	0.6%
31-10-2018	3357	0.6%
Other values (120)	187555	31.9%
(Missing)	365212	62.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
31-10-2019	3819	1.7%
31-12-2019	3779	1.7%
30-04-2019	3604	1.6%
31-12-2017	3516	1.6%
31-08-2019	3484	1.6%
30-09-2019	3444	1.5%
31-08-2018	3440	1.5%
31-05-2019	3430	1.5%
31-03-2019	3413	1.5%
31-10-2018	3357	1.5%
Other values (120)	187555	84.2%

Most occurring characters

Value	Count	Frequency (%)
0	501929	22.5%
-	445682	20.0%
1	427536	19.2%
2	306218	13.7%
3	236980	10.6%
8	70198	3.2%
9	63765	2.9%
7	52773	2.4%
6	46109	2.1%
5	41707	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1782728	80.0%
Dash Punctuation	445682	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	501929	28.2%
1	427536	24.0%
2	306218	17.2%
3	236980	13.3%
8	70198	3.9%
9	63765	3.6%
7	52773	3.0%
6	46109	2.6%
5	41707	2.3%
4	35513	2.0%

Dash Punctuation

Value	Count	Frequency (%)
-	445682	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2228410	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	501929	22.5%
-	445682	20.0%
1	427536	19.2%
2	306218	13.7%
3	236980	10.6%
8	70198	3.2%
9	63765	2.9%
7	52773	2.4%
6	46109	2.1%
5	41707	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2228410	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	501929	22.5%
-	445682	20.0%
1	427536	19.2%
2	306218	13.7%
3	236980	10.6%
8	70198	3.2%
9	63765	2.9%
7	52773	2.4%
6	46109	2.1%
5	41707	1.9%

ChargeOffDate
Categorical

HIGH CARDINALITY MISSING

Distinct	2184
Distinct (%)	10.6%
Missing	567384
Missing (%)	96.5%
Memory size	4.5 MiB

22-02-2019	70
24-03-2020	69
07-02-2019	59
03-03-2020	56
12-02-2019	56
Other values (2179)	20359

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	206690
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	243 ?
Unique (%)	1.2%

Sample

1st row	24-08-2015
2nd row	16-05-2016
3rd row	12-02-2018
4th row	01-03-2011
5th row	03-12-2012

Common Values

Value	Count	Frequency (%)
22-02-2019	70	< 0.1%
24-03-2020	69	< 0.1%
07-02-2019	59	< 0.1%
03-03-2020	56	< 0.1%
12-02-2019	56	< 0.1%
15-03-2018	51	< 0.1%
16-03-2017	49	< 0.1%
02-01-2018	48	< 0.1%
14-02-2019	47	< 0.1%
12-03-2018	47	< 0.1%
Other values (2174)	20117	3.4%
(Missing)	567384	96.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
22-02-2019	70	0.3%
24-03-2020	69	0.3%
07-02-2019	59	0.3%
03-03-2020	56	0.3%
12-02-2019	56	0.3%
15-03-2018	51	0.2%
16-03-2017	49	0.2%
02-01-2018	48	0.2%
14-02-2019	47	0.2%
12-03-2018	47	0.2%
Other values (2174)	20117	97.3%

Most occurring characters

Value	Count	Frequency (%)
0	48909	23.7%
-	41338	20.0%
2	35839	17.3%
1	34700	16.8%
8	7727	3.7%
9	7709	3.7%
7	6581	3.2%
6	6516	3.2%
3	6250	3.0%
5	5784	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	165352	80.0%
Dash Punctuation	41338	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	48909	29.6%
2	35839	21.7%
1	34700	21.0%
8	7727	4.7%
9	7709	4.7%
7	6581	4.0%
6	6516	3.9%
3	6250	3.8%
5	5784	3.5%
4	5337	3.2%

Dash Punctuation

Value	Count	Frequency (%)
-	41338	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	206690	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	48909	23.7%
-	41338	20.0%
2	35839	17.3%
1	34700	16.8%
8	7727	3.7%
9	7709	3.7%
7	6581	3.2%
6	6516	3.2%
3	6250	3.0%
5	5784	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	206690	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	48909	23.7%
-	41338	20.0%
2	35839	17.3%
1	34700	16.8%
8	7727	3.7%
9	7709	3.7%
7	6581	3.2%
6	6516	3.2%
3	6250	3.0%
5	5784	2.8%

GrossChargeOffAmount
Real number (ℝ)

SKEWED ZEROS

Distinct	17960
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4305.2546

Minimum	0
Maximum	4706180
Zeros	567384
Zeros (%)	96.5%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	4706180
Range	4706180
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	50350.344
Coefficient of variation (CV)	11.695091
Kurtosis	1388.0567
Mean	4305.2546
Median Absolute Deviation (MAD)	0
Skewness	29.433801
Sum	2.5317179 × 10⁹
Variance	2.5351571 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	567384	96.5%
25000	181	< 0.1%
50000	99	< 0.1%
10000	92	< 0.1%
100000	59	< 0.1%
20000	53	< 0.1%
15000	42	< 0.1%
24999	31	< 0.1%
5000	29	< 0.1%
350000	27	< 0.1%
Other values (17950)	20056	3.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	567384	96.5%
11	1	< 0.1%
60	1	< 0.1%
98	1	< 0.1%
109	1	< 0.1%
179	1	< 0.1%
184	1	< 0.1%
223	1	< 0.1%
228	1	< 0.1%
250	1	< 0.1%

Value	Count	Frequency (%)
4706180	1	< 0.1%
4334490	1	< 0.1%
4254436	1	< 0.1%
4084959	1	< 0.1%
4002876	1	< 0.1%
3867035	1	< 0.1%
3730328	1	< 0.1%
3498136	1	< 0.1%
3418147	1	< 0.1%
3403551	1	< 0.1%

RevolverStatus
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

0	402998
1	185055

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	588053
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	402998	68.5%
1	185055	31.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	402998	68.5%
1	185055	31.5%

Most occurring characters

Value	Count	Frequency (%)
0	402998	68.5%
1	185055	31.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	588053	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	402998	68.5%
1	185055	31.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	588053	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	402998	68.5%
1	185055	31.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	588053	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	402998	68.5%
1	185055	31.5%

JobsSupported
Real number (ℝ)

Distinct	312
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.720804

Minimum	0
Maximum	2150
Zeros	93989
Zeros (%)	16.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	11
95-th percentile	41
Maximum	2150
Range	2150
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	20.425223
Coefficient of variation (CV)	1.9051951
Kurtosis	290.78397
Mean	10.720804
Median Absolute Deviation (MAD)	4
Skewness	8.1718161
Sum	6304401
Variance	417.18973
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	93989	16.0%
2	65142	11.1%
1	48415	8.2%
4	43341	7.4%
3	42502	7.2%
5	33952	5.8%
6	29927	5.1%
10	23149	3.9%
8	20835	3.5%
7	19374	3.3%
Other values (302)	167427	28.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	93989	16.0%
1	48415	8.2%
2	65142	11.1%
3	42502	7.2%
4	43341	7.4%
5	33952	5.8%
6	29927	5.1%
7	19374	3.3%
8	20835	3.5%
9	11759	2.0%

Value	Count	Frequency (%)
2150	1	< 0.1%
1155	1	< 0.1%
1011	1	< 0.1%
850	1	< 0.1%
750	1	< 0.1%
725	1	< 0.1%
600	1	< 0.1%
570	1	< 0.1%
480	1	< 0.1%
460	2	< 0.1%

Auto

Heatmap
Table

	BorrZip	GrossApproval	SBAGuaranteedApproval	ApprovalFiscalYear	InitialInterestRate	TermInMonths	NaicsCode	CongressionalDistrict	GrossChargeOffAmount	JobsSupported	BorrState	BankState	DeliveryMethod	subpgmdesc	ProjectState	SBADistrictOffice	BusinessType	LoanStatus	RevolverStatus
BorrZip	1.000	0.102	0.111	-0.011	0.010	0.115	-0.002	0.135	0.002	0.057	0.956	0.566	0.104	0.095	0.955	0.951	0.089	0.034	0.115
GrossApproval	0.102	1.000	0.993	0.071	-0.413	0.597	0.057	0.054	-0.078	0.437	0.064	0.103	0.196	0.195	0.064	0.066	0.059	0.053	0.306
SBAGuaranteedApproval	0.111	0.993	1.000	0.064	-0.408	0.618	0.068	0.049	-0.071	0.436	0.054	0.089	0.174	0.174	0.054	0.056	0.050	0.041	0.239
ApprovalFiscalYear	-0.011	0.071	0.064	1.000	0.220	0.171	0.028	0.032	-0.117	-0.051	0.042	0.084	0.144	0.140	0.042	0.046	0.054	0.352	0.059
InitialInterestRate	0.010	-0.413	-0.408	0.220	1.000	-0.112	-0.003	0.017	0.056	-0.191	0.087	0.162	0.154	0.153	0.087	0.095	0.064	0.084	0.377
TermInMonths	0.115	0.597	0.618	0.171	-0.112	1.000	0.132	0.065	-0.193	0.179	0.126	0.192	0.286	0.284	0.127	0.130	0.075	0.154	0.478
NaicsCode	-0.002	0.057	0.068	0.028	-0.003	0.132	1.000	0.019	-0.008	0.125	0.112	0.136	0.102	0.102	0.112	0.117	0.139	0.034	0.224
CongressionalDistrict	0.135	0.054	0.049	0.032	0.017	0.065	0.019	1.000	0.009	-0.002	0.367	0.206	0.045	0.039	0.367	0.568	0.054	0.016	0.043
GrossChargeOffAmount	0.002	-0.078	-0.071	-0.117	0.056	-0.193	-0.008	0.009	1.000	-0.010	0.007	0.012	0.020	0.018	0.007	0.007	0.008	0.111	0.024
JobsSupported	0.057	0.437	0.436	-0.051	-0.191	0.179	0.125	-0.002	-0.010	1.000	0.005	0.010	0.014	0.013	0.005	0.007	0.007	0.004	0.011
BorrState	0.956	0.064	0.054	0.042	0.087	0.126	0.112	0.367	0.007	0.005	1.000	0.525	0.153	0.138	0.998	0.923	0.144	0.052	0.160
BankState	0.566	0.103	0.089	0.084	0.162	0.192	0.136	0.206	0.012	0.010	0.525	1.000	0.210	0.183	0.525	0.515	0.120	0.088	0.388
DeliveryMethod	0.104	0.196	0.174	0.144	0.154	0.286	0.102	0.045	0.020	0.014	0.153	0.210	1.000	0.889	0.153	0.155	0.088	0.121	0.658
subpgmdesc	0.095	0.195	0.174	0.140	0.153	0.284	0.102	0.039	0.018	0.013	0.138	0.183	0.889	1.000	0.138	0.141	0.088	0.118	0.678
ProjectState	0.955	0.064	0.054	0.042	0.087	0.127	0.112	0.367	0.007	0.005	0.998	0.525	0.153	0.138	1.000	0.925	0.144	0.052	0.160
SBADistrictOffice	0.951	0.066	0.056	0.046	0.095	0.130	0.117	0.568	0.007	0.007	0.923	0.515	0.155	0.141	0.925	1.000	0.153	0.055	0.163
BusinessType	0.089	0.059	0.050	0.054	0.064	0.075	0.139	0.054	0.008	0.007	0.144	0.120	0.088	0.088	0.144	0.153	1.000	0.035	0.032
LoanStatus	0.034	0.053	0.041	0.352	0.084	0.154	0.034	0.016	0.111	0.004	0.052	0.088	0.121	0.118	0.052	0.055	0.035	1.000	0.087
RevolverStatus	0.115	0.306	0.239	0.059	0.377	0.478	0.224	0.043	0.024	0.011	0.160	0.388	0.658	0.678	0.160	0.163	0.032	0.087	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	AsOfDate	Program	BorrName	BorrStreet	BorrCity	BorrState	BorrZip	BankName	BankStreet	BankCity	BankState	BankZip	GrossApproval	SBAGuaranteedApproval	ApprovalDate	ApprovalFiscalYear	FirstDisbursementDate	DeliveryMethod	subpgmdesc	InitialInterestRate	TermInMonths	NaicsCode	NaicsDescription	FranchiseCode	FranchiseName	ProjectCounty	ProjectState	SBADistrictOffice	CongressionalDistrict	BusinessType	LoanStatus	PaidInFullDate	ChargeOffDate	GrossChargeOffAmount	RevolverStatus	JobsSupported
0	20200930	7A	CRESA PARTNERS - DENVER, INC.	7979 E TUFTS AVE PKWY STE 810	DENVER	CO	80237	Zions Bank, A Division of	1 S Main St	SALT LAKE CITY	UT	84133	250000	125000	01-10-2009	2010	01-10-2009	SBA EXPRES	FA$TRK (Small Loan Express)	5.26	84	531210.0	Offices of Real Estate Agents and Brokers	NaN	NaN	DENVER	CO	COLORADO DISTRICT OFFICE	1.0	CORPORATION	PIF	31-10-2016	NaN	0	1	35
1	20200930	7A	The Hilltop Tavern	4757 Folsom Blvd	Sacramento	CA	95819	Plumas Bank	336 W Main St	QUINCY	CA	95971	233500	210150	01-10-2009	2010	01-10-2009	PLP	Guaranty	6.00	120	722410.0	Drinking Places (Alcoholic Beverages)	NaN	NaN	SACRAMENTO	CA	SACRAMENTO DISTRICT OFFICE	6.0	CORPORATION	PIF	31-03-2019	NaN	0	0	6
2	20200930	7A	River City Car Wash LLC	649 Harbor Blvd	West Sacramento	CA	95691	Wells Fargo Bank, National Association	101 N Philips Ave	SIOUX FALLS	SD	57104	683900	615510	01-10-2009	2010	01-11-2009	PLP	Guaranty	5.25	210	811192.0	Car Washes	NaN	NaN	YOLO	CA	SACRAMENTO DISTRICT OFFICE	3.0	CORPORATION	CHGOFF	NaN	24-08-2015	320098	0	27
3	20200930	7A	Alphagraphics	71 Newtown Road.	Danbury	CT	6810	Union Savings Bank	226 Main St	DANBURY	CT	6810	100000	50000	01-10-2009	2010	01-10-2009	SBA EXPRES	FA$TRK (Small Loan Express)	5.25	84	323110.0	Commercial Lithographic Printing	03512	ALPHAGRAPHICS, PRINTSHOPS OF T	FAIRFIELD	CT	CONNECTICUT DISTRICT OFFICE	5.0	CORPORATION	EXEMPT	NaN	NaN	0	1	5
4	20200930	7A	ON SITE AUTOMOTIVE APPEARANCE	603 WOODBRIDGE COURT	MIDDLEBURY	IN	46540	VelocitySBA, LLC	9385 Haven Avenue	Rancho Cucamonga	CA	91730	12500	11250	01-10-2009	2010	01-10-2009	COMM EXPRS	Community Express	7.75	120	811121.0	Automotive Body, Paint, and Interior Repair and Maintenance	NaN	NaN	ELKHART	IN	INDIANA DISTRICT OFFICE	3.0	INDIVIDUAL	PIF	28-02-2013	NaN	0	0	2
5	20200930	7A	AW ENTERPRISES	106 WEST LAKE STREET	CAMDEN	TN	38320	VelocitySBA, LLC	9385 Haven Avenue	Rancho Cucamonga	CA	91730	10000	9000	01-10-2009	2010	01-10-2009	COMM EXPRS	Community Express	7.24	120	453220.0	Gift, Novelty, and Souvenir Stores	NaN	NaN	BENTON	TN	TENNESSEE DISTRICT OFFICE	7.0	INDIVIDUAL	PIF	31-10-2019	NaN	0	0	3
6	20200930	7A	TA SPECIALTY	331 HEATHERSTONE ROAD	COLUMBIA	SC	29212	VelocitySBA, LLC	9385 Haven Avenue	Rancho Cucamonga	CA	91730	20000	18000	01-10-2009	2010	01-10-2009	PATRIOT EX	Patriot Express	7.75	120	541890.0	Other Services Related to Advertising	NaN	NaN	LEXINGTON	SC	SOUTH CAROLINA DISTRICT OFFICE	2.0	INDIVIDUAL	PIF	31-03-2017	NaN	0	0	4
7	20200930	7A	Hansen Concrete, Inc.	8656 71st Street NE	SPICER	MN	56288	Lake Region Bank	51 Main St	NEW LONDON	MN	56273	200000	100000	01-10-2009	2010	01-12-2009	SBA EXPRES	FA$TRK (Small Loan Express)	7.50	60	236220.0	Commercial and Institutional Building Construction	NaN	NaN	KANDIYOHI	MN	MINNESOTA DISTRICT OFFICE	7.0	CORPORATION	PIF	29-02-2012	NaN	0	1	12
8	20200930	7A	SHADIA'S SECRETS INC	950 GLADES RD 2ND FLOOR	BOCA RATON	FL	33431	VelocitySBA, LLC	9385 Haven Avenue	Rancho Cucamonga	CA	91730	15000	13500	01-10-2009	2010	01-10-2009	COMM EXPRS	Community Express	7.75	120	446199.0	All Other Health and Personal Care Stores	NaN	NaN	PALM BEACH	FL	SOUTH FLORIDA DISTRICT OFFICE	22.0	CORPORATION	PIF	31-10-2019	NaN	0	0	1
9	20200930	7A	JT'S COFFEE AND SANDWICH SHOP	1167 HARRISON STREET	SAN FRANCISCO	CA	94103	VelocitySBA, LLC	9385 Haven Avenue	Rancho Cucamonga	CA	91730	20000	18000	01-10-2009	2010	01-10-2009	COMM EXPRS	Community Express	7.75	120	722213.0	Snack and Nonalcoholic Beverage Bars	NaN	NaN	SAN FRANCISCO	CA	SAN FRANCISCO DISTRICT OFFICE	12.0	CORPORATION	PIF	31-10-2017	NaN	0	0	4

	AsOfDate	Program	BorrName	BorrStreet	BorrCity	BorrState	BorrZip	BankName	BankStreet	BankCity	BankState	BankZip	GrossApproval	SBAGuaranteedApproval	ApprovalDate	ApprovalFiscalYear	FirstDisbursementDate	DeliveryMethod	subpgmdesc	InitialInterestRate	TermInMonths	NaicsCode	NaicsDescription	FranchiseCode	FranchiseName	ProjectCounty	ProjectState	SBADistrictOffice	CongressionalDistrict	BusinessType	LoanStatus	PaidInFullDate	ChargeOffDate	RevolverStatus	JobsSupported
588043	20200930	7A	MSA Building LLC	16535 Grand River Ave	Detroit	MI	48227	The Huntington National Bank	17 S High St	COLUMBUS	OH	43215.0	479400	359550	30-09-2020	2020	NaN	PLP	Guaranty	6.00	180	445310.0	Beer, Wine, and Liquor Stores	NaN	NaN	WAYNE	MI	MICHIGAN DISTRICT OFFICE	14.0	CORPORATION	COMMIT	NaN	NaN	0	4
588044	20200930	7A	Apponaug Animal Hospital, Inc.	61 Gilbane Street a/k/a 42 B	Warwick	RI	2886	HarborOne Bank	770 Oak St	BROCKTON	MA	2301.0	180000	135000	30-09-2020	2020	NaN	PLP	Guaranty	4.25	120	541940.0	Veterinary Services	NaN	NaN	KENT	RI	RHODE ISLAND DISTRICT OFFICE	2.0	CORPORATION	COMMIT	NaN	NaN	0	6
588045	20200930	7A	Brass and rose-Kyle LLC	5401 FM 1626 #200	Kyle	TX	78640	Wallis Bank	6510 Railroad St	WALLIS	TX	77485.0	261000	195750	30-09-2020	2020	NaN	PLP	Guaranty	5.00	126	812990.0	All Other Personal Services	S0101	Amazing Lash Studio	HAYS	TX	SAN ANTONIO DISTRICT OFFICE	35.0	PARTNERSHIP	COMMIT	NaN	NaN	0	52
588046	20200930	7A	GODINEZ LOGISTICS LLC	7704 CLEARWATER AVE W	KENNEWICK	WA	99336	U.S. Bank, National Association	425 Walnut St	CINCINNATI	OH	45202.0	19000	9500	30-09-2020	2020	NaN	SBA EXPRES	FA$TRK (Small Loan Express)	5.24	60	484121.0	General Freight Trucking, Long Distance, Truckload	NaN	NaN	BENTON	WA	SPOKANE BRANCH OFFICE	4.0	CORPORATION	COMMIT	NaN	NaN	0	1
588047	20200930	7A	DazDan Foods LLC	177 Elton Adelphia Road	Freehold	NJ	7728	Trenton Business Assistance Corporation	3111 Quakerbridge Road	Mercerville	NJ	8619.0	200000	150000	30-09-2020	2020	NaN	CA	Community Advantage Initiative	5.25	120	445299.0	All Other Specialty Food Stores	NaN	NaN	MONMOUTH	NJ	NEW JERSEY DISTRICT OFFICE	4.0	CORPORATION	COMMIT	NaN	NaN	0	15
588048	20200930	7A	Lincoln Alan Construction Grou	9120 Crackle Rd	Chagrin Falls	OH	44023	The Huntington National Bank	17 S High St	COLUMBUS	OH	43215.0	200000	100000	30-09-2020	2020	NaN	SBA EXPRES	FA$TRK (Small Loan Express)	5.50	120	236118.0	Residential Remodelers	NaN	NaN	GEAUGA	OH	CLEVELAND DISTRICT OFFICE	14.0	CORPORATION	COMMIT	NaN	NaN	1	0
588049	20200930	7A	PFFL Holdings, LLC	601 CHURCH ST	NASHVILLE	TN	37219	CapStar Bank	1201 Demonbreun St	NASHVILLE	TN	37203.0	783500	587625	30-09-2020	2020	NaN	PLP	Guaranty	6.00	126	722511.0	Full-Service Restaurants	S3558	COPPER BRANCH	DAVIDSON	TN	TENNESSEE DISTRICT OFFICE	5.0	CORPORATION	COMMIT	NaN	NaN	0	17
588050	20200930	7A	PFFL Holdings, LLC	601 CHURCH ST	NASHVILLE	TN	37219	CapStar Bank	1201 Demonbreun St	NASHVILLE	TN	37203.0	150000	75000	30-09-2020	2020	NaN	PLP	Guaranty	6.00	120	722511.0	Full-Service Restaurants	S3558	COPPER BRANCH	DAVIDSON	TN	TENNESSEE DISTRICT OFFICE	5.0	CORPORATION	COMMIT	NaN	NaN	0	17
588051	20200930	7A	Norkobe's Beauty	701 N STATE ROAD 7	MARGATE	FL	33063	Harvest Small Business Finance, LLC	24422 Avenida de la Carlota	Laguna Hills	CA	92653.0	620000	465000	30-09-2020	2020	NaN	PLP	Guaranty	6.00	300	812112.0	Beauty Salons	NaN	NaN	BROWARD	FL	SOUTH FLORIDA DISTRICT OFFICE	22.0	CORPORATION	COMMIT	NaN	NaN	0	16
588052	20200930	7A	Prestigious Appliance LLC	1118 Gary Alan Trace	Moody	AL	35004	Progress Bank and Trust	201 Williams Ave	HUNTSVILLE	AL	35801.0	261000	195750	30-09-2020	2020	NaN	OTH 7A	Guaranty	6.00	120	443141.0	Household Appliance Stores	NaN	NaN	SAINT CLAIR	AL	ALABAMA DISTRICT OFFICE	3.0	CORPORATION	COMMIT	NaN	NaN	0	8

Most frequently occurring

	AsOfDate	Program	BorrName	BorrStreet	BorrCity	BorrState	BorrZip	BankName	BankStreet	BankCity	BankState	GrossApproval	SBAGuaranteedApproval	ApprovalDate	ApprovalFiscalYear	FirstDisbursementDate	DeliveryMethod	subpgmdesc	InitialInterestRate	TermInMonths	NaicsCode	NaicsDescription	FranchiseCode	FranchiseName	ProjectCounty	ProjectState	SBADistrictOffice	CongressionalDistrict	BusinessType	LoanStatus	PaidInFullDate	ChargeOffDate	RevolverStatus	JobsSupported	# duplicates
195	20200930	7A	Cedar Investments, LLC	1210 N. Stone Ave.	Tucson	AZ	85705	Bank of the West	180 Montgomery St	SAN FRANCISCO	CA	277700	208275	21-10-2019	2020	NaN	PLP	Guaranty	4.78	300	561421.0	Telephone Answering Services	NaN	NaN	PIMA	AZ	ARIZONA DISTRICT OFFICE	3.0	CORPORATION	CANCLD	NaN	NaN	0	0	8
904	20200930	7A	Van Row Mechanical, Inc.	1225 Avenue C	White City	OR	97503	People's Bank of Commerce	1311 E Barnett Rd	MEDFORD	OR	60000	51000	31-10-2011	2012	NaN	PATRIOT EX	Patriot Express	5.25	12	238220.0	Plumbing, Heating, and Air-Conditioning Contractors	NaN	NaN	JACKSON	OR	PORTLAND DISTRICT OFFICE	2.0	CORPORATION	CANCLD	NaN	NaN	1	4	8
339	20200930	7A	GONZO'S BASIC SOLUTIONS	1921 EAST CARNEGIE AVE SUITE	SANTA ANA	CA	92705	American Plus Bank, National Association	630 W Duarte Rd	ARCADIA	CA	445000	333750	03-10-2012	2013	NaN	PLP	Guaranty	4.50	300	424210.0	Drugs and Druggists' Sundries Merchant Wholesalers	NaN	NaN	ORANGE	CA	SANTA ANA DISTRICT OFFICE	45.0	CORPORATION	CANCLD	NaN	NaN	0	2	7
581	20200930	7A	Martin Bionics Innovations LLC	214 E. MAIN ST	OKLAHOMA CITY	OK	73104	BancFirst	101 N Broadway, Ste 1050	OKLAHOMA CITY	OK	250000	187500	11-03-2020	2020	NaN	PLP	Guaranty	5.75	84	541990.0	All Other Professional, Scientific, and Technical Services	NaN	NaN	OKLAHOMA	OK	OKLAHOMA DISTRICT OFFICE	5.0	CORPORATION	COMMIT	NaN	NaN	0	50	7
907	20200930	7A	Vela Transport LLC	5459 Crippen Ave SW	Wyoming	MI	49548	The Huntington National Bank	17 S High St	COLUMBUS	OH	21400	10700	14-03-2014	2014	01-04-2014	SBA EXPRES	FA$TRK (Small Loan Express)	4.90	60	484230.0	Specialized Freight (except Used Goods) Trucking, Long-Distance	NaN	NaN	KENT	MI	MICHIGAN DISTRICT OFFICE	3.0	CORPORATION	PIF	30-04-2019	NaN	0	4	7
391	20200930	7A	Happy Start, Inc.	2280 Bypass 35	Alvin	TX	77511	Texas Advantage Community Bank, National Association	1701 Fairway Plaza, Ste 18	ALVIN	TX	1064000	798000	05-10-2015	2016	NaN	OTH 7A	Guaranty	5.50	240	624410.0	Child Day Care Services	NaN	NaN	BRAZORIA	TX	HOUSTON DISTRICT OFFICE	14.0	CORPORATION	CANCLD	NaN	NaN	0	0	6
499	20200930	7A	L&E Transport, LLC	2250 N Whistlevale Dr SW	Bryon Center	MI	49315	The Huntington National Bank	17 S High St	COLUMBUS	OH	53100	26550	25-01-2017	2017	01-02-2017	SBA EXPRES	FA$TRK (Small Loan Express)	6.50	60	484121.0	General Freight Trucking, Long Distance, Truckload	NaN	NaN	KENT	MI	MICHIGAN DISTRICT OFFICE	3.0	CORPORATION	EXEMPT	NaN	NaN	0	6	6
502	20200930	7A	LCTC, INC.	5084 NORTH FRUIT AVENUE SUITE	FRESNO	CA	93711	Premier Valley Bank	255 E River Park Circle Dr, St	FRESNO	CA	300000	225000	23-09-2011	2011	NaN	PLP	Guaranty	6.00	120	621610.0	Home Health Care Services	NaN	NaN	FRESNO	CA	FRESNO DISTRICT OFFICE	22.0	CORPORATION	CANCLD	NaN	NaN	0	3	6
604	20200930	7A	Mopho Group, LLC	514 City Park Avenue, suite	New Orleans	LA	70119	Gulf Coast Bank and Trust Company	200 St. Charles Ave	NEW ORLEANS	LA	520000	390000	25-07-2013	2013	NaN	PLP	Guaranty	6.50	120	722511.0	Full-Service Restaurants	NaN	NaN	ORLEANS	LA	LOUISIANA DISTRICT OFFICE	2.0	CORPORATION	CANCLD	NaN	NaN	0	29	6
636	20200930	7A	North Terrace PM LLC	4344 Belleview Ave	Kansas City	MO	64111	Bank of the West	180 Montgomery St	SAN FRANCISCO	CA	100000	85000	23-01-2018	2018	NaN	PLP	Guaranty	7.25	120	531110.0	Lessors of Residential Buildingsv and Dwellings	NaN	NaN	JACKSON	MO	KANSAS CITY DISTRICT OFFICE	5.0	CORPORATION	CANCLD	NaN	NaN	0	0	6

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Open Punctuation

Close Punctuation

Modifier Symbol

Space Separator

Dash Punctuation

Connector Punctuation

Currency Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Modifier Symbol

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Connector Punctuation

Currency Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values